We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Excel Function

Moiz Saif
Moiz Saif asked
on
Medium Priority
211 Views
Last Modified: 2012-05-11
I work for a company that completes Service Orders as a task and the team needs to complete atleast 30 S.O to receive money.

I need a function in excel that computes the math.

So if the number is > than 30 then 30/6 where 6 is the number of working days which is equivalent to 5/day then 5*30 is the amount they receive which is 150. I need a function to compute the math to output 150$
Although if the number of input is 31 then 31/6 is 5.1666 which should be rounded to 5

Another function similar to above should be used
((30/6)*40%)*30
Comment
Watch Question

Moizsaif, sorry your question isn't very clear, especially the bit about "another" formula.

When do you round up, if ever? What happens if the SO total gets to say 50?

Author

Commented:
round up only on the division part of the function portion so say if total is 50 then 50/6=8.33 rounded up to 8

My condition states for a total below 30 should not be considered and the output is 0.
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
let's assume u have your SO count in cell "A1"

Formula 1:
========
then the function should read" =rounddown($A$1/6,0)*30


Formula 2:
========
=(rounddown((30/6),0)*40%)*30

let me know if it helps!!!

Thanks,
Bala
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.