# Thread: Needing help with an IF formula?

1. ## Needing help with an IF formula?

Register for a FREE account, and/
or Log in to avoid these ads!

Admittedly I'm hopeless with Excel, I'm desperately trying but not succeeding at this point with something. I was wondering if anyone could help possibly?

Trying to work out how to do an IF query in Excel. Attempting to set up some basic stuff for work.

Commission rate A 4% is in B6, Commission rate B 8% is in C6.
Commission Limit of 1000 A is in B7 and Limit 2000 B is in C7.

What I'm trying to work out, is how to do it so that if my guys sell enough during the week (we only run a family furniture business, starting out), how to calculate their comission.

If B12 is where their sales go, and c12 is where I want the commission to be calculated to, how do I work it so that IF its equal to or greater than 2000, it's calculated by 8%, IF its greater than 1000 but less than 2000 the get 4%. If they sell under 1000 a week they get 0?

I've been trying all day and just can't get it. Advice?

2. In C12 use this formula

=IF(B12<1000,0,IF(AND(B12>999,B12<2000),B12*B6,B12*C6))

3. A minor change as an alternative:

Code:
`=IF(B12<B7,0,IF(AND(B12>=B7,B12<C7),B12*B6,B12*C6))`

4. ## Fantastic

Originally Posted by CheshireCat
A minor change as an alternative:

Code:
`=IF(B12<B7,0,IF(AND(B12>=B7,B12<C7),B12*B6,B12*C6))`

It worked perfectly, thank you both so much

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•