<div>
Moizsaif, sorry your question isn't very clear, especially the bit about &quot;another&quot; formula. <br />
<br />
When do you round up, if ever? What happens if the SO total gets to say 50?<br />

</div>


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?


<div>
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<br />
<br />
My condition states for a total below 30 should not be considered and the output is 0.
</div>


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.

<div>
let's assume u have your SO count in cell &quot;A1&quot;<br />
<br />
Formula 1:<br />
========<br />
then the function should read&quot; =rounddown($A$1/6,0)*30<br />
<br />
<br />
Formula 2:<br />
========<br />
=(rounddown((30/6),0)*40%)<wbr />*30<br />
<br />
let me know if it helps!!!<br />
<br />
Thanks,<br />
Bala
</div>


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

<div>
<div class="content wysiwyg-content">
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. <br />
<br />
I need a function in excel that computes the math.<br />
<br />
So if the number is &gt;&nbsp;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$ <br />
Although if the number of input is 31 then 31/6 is 5.1666 which should be rounded to 5<br />
<br />
Another function similar to above should be used<br />
((30/6)*40%)*30<br />

</div>
</div>


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


Excel Function

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.