Commission - IF formulas
GREAT, it worked!!!
"Bob I" wrote:
Try this
=IF((C224499)+(C22<2600),0,C22*0.25)
VT - Maryland wrote:
This is what I want:
<2600 - should equal $0.00
2600 <4499 - should equal 25% of the amount over $2,600 and less than the amount $4,499
and
=4500 - should equal $0.00
If Cell C22 is at least $2,600 and not larger than $4,499 returns a
commission of 25% of the amount. If cell c22 is$2,499 returns $0.00. If
cell c22 is $4,500 returns a zero $0.00
"Bob I" wrote:
there are three outcomes, what do you want for
=<2600
2600 <4499
and
=4500
currently nothing is set for 4500 only greater than which doesn't match
your stated desire.
VT - Maryland wrote:
I need formula for commission of 25% if cell c22 is greater than $2,600. and
less than $4,499. I keep trying =IF(C224500,"0",IF(C22<2600,"c22*25%"))
with a value in cell c22 of $4,500, but I get the result of FALSE instead of
zero.
|