Needing help with an IF formula?

weresmurf

New member
Joined
Sep 16, 2012
Messages
2
Reaction score
0
Points
0
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?
 

tommyt61

New member
Joined
Mar 26, 2011
Messages
153
Reaction score
0
Points
0
In C12 use this formula

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

CheshireCat

New member
Joined
Dec 30, 2011
Messages
121
Reaction score
0
Points
0
Location
Victoria, Canada
Excel Version(s)
Microsoft Excel 2013
A minor change as an alternative:

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