Excel Function

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
LVL 4
Moizsaif123Asked:
Who is Participating?
 
RunriggerCommented:
IF(A1<30,0,INT(A1/6)*30)
IF(A1<30,0,INT(A1/6)*0.4*30)

Where A1 holds the number of SO's
0
 
RunriggerCommented:
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?
0
 
Moizsaif123Author 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.
0
 
balatheexpertCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.