# Excel Formula

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### Moby01

My question is how do I input a formula into Office 2010 Excel that calculates set commission amounts (\$100,\$150,\$200,&\$250) for various dollar sales amounts?
I have been able to work it this far:
=IF(D4>2999,D4<4000)*("\$200.00")
The part I need to know is how do I expand this formula to include the next level of commission pay off \$250.00
How close am I?
=IF(D4>2999,D4<4000)*("\$200.00") (D4>=4000)*("\$250.00")
I am not sure how I join or add the brackets together.
I appreciate you help.

#### etaf

Wayne
Moderator
use nested IFs

so

IF( test , true , false )

now to nest in the false section (you can also nest in true)

IF( test, true, IF(test, true, false) )

if you want to give the details , i can set up

=IF(D4>2999,D4<4000)*("\$200.00")
not sure why thats works

I would also look at the structure of the data and you may avoid using the between

but for between use

AND( D4>2999,D4<4000)
as the test

IF( D4 > 4000, "4001+ commision calc", if(d4> 2999, "3000+ commision calc", if( d4>1000, "1001+ commision calc", "value for below or equal 1000")

if you want to include greater or =
>=

the tests are carried out in the order written
so if its false for >4000 - then the next test shows below 4001 but greater than 2999

#### Moby01

Thank you for your advice it helped me out in exactly the right way.
This was the first time for me on any forum, I enjoyed this experience.
I also like the various subjects that are discussed on TechGuy.
Regards

Moby01

#### etaf

Wayne
Moderator
your welcome thanks for letting us know
button at the top of the page of the thread in the upper left corner.

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On