Multiply IF function needed

[excelnoob9]

Hello All,

I am trying to build a spreadsheet to generate sales commission if their production is over a certain amount.

For instance, if they produce $1.25mil they get $1.25 per thousand dollars if it below $1.25mil it will be $1 per thousand. So if they do the $1.25mil their commission would end of being $1562.50. If their production was $1,249,999.99 their commission would be $1249.99.


[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Monthly Production[/TD]
[TD]$1,250,000.00[/TD]
[/TR]
[TR]
[TD]Commission[/TD]
[TD]X[/TD]
[/TR]
</tbody>[/TABLE]
$1.25/per thousand




[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Monthly Production[/TD]
[TD]$1,249,999.99[/TD]
[/TR]
[TR]
[TD]Commission[/TD]
[TD]X[/TD]
[/TR]
</tbody>[/TABLE]

$1/per thousand



Thanks!

 

[Joe4]

Welcome to the Board!

If their production was $1,249,999.99 their commission would be $1249.99.

That leads me to believe that it is really 0.1% as opposed to $1 per thousand, or else they could only receive whole dollars (i.e. $1249.00).
If that is the case, try this:

=B1*IF(B1>=1250000,.00125,.001)

for a value in cell B1.