Commission - IF formulas

[VT - Maryland]

I need formula for commission of 25% if cell c22 is greater than $2,600. and
less than $4,499. I keep trying =IF(C22>4500,"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.

 

[Bob I]

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.

 

[Pete_UK]

You don't need those quotes - this turns the number into text. I would
suggest that you need to do this:

=IF(AND(C22<4500,C22>2600),C22*25%,0)

Ensure that the value in C22 is a proper number, and not a text value.
You should type 4500 and if the cell is formatted to show a currency
symbol and a comma separating thousands, then it will display as
$4,500 - you do not type it in like this as it will then be treated as
text.

Hope this helps.

Pete

 

[VT - Maryland]

This is what I want:
<2600 - 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]

Try this

=IF((C22>4499)+(C22<2600),0,C22*0.25)

This is what I want:
<2600 - 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


:

 

[VT - Maryland]

GREAT, it worked!!!

Try this

=IF((C22>4499)+(C22<2600),0,C22*0.25)

 

[Shane Devenshire]

Here are two addtional solutions:

=IF(AND(A1>2600,A1<4499),25%)*A1
and even shorter
=((A1>2600)+(A1<4499))*A1*0.125

 

[Bob I]

You're welcome, have a great day!

GREAT, it worked!!!

: