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