Commission - IF formulas
 

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.

Commission - IF formulas
 

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.

Commission - IF formulas
 

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,C222600),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

On Sep 4, 4:34*pm, VT - Maryland <VT -
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.

Commission - IF formulas
 

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.

Commission - IF formulas
 

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.

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.

Commission - IF formulas
 

Here are two addtional solutions:

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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.

Commission - IF formulas
 

Didn't the OP want a result of zero if A1 is outside the 2600 to 4499 range?
Are you sure that =((A12600)+(A1<4499))*A1*0.125 gives that?
--
David Biddulph

Shane Devenshire wrote:
Here are two addtional solutions:

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


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.

Commission - IF formulas
 

You're welcome, have a great day!

VT - Maryland wrote:

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.