Conditional Formula

[nikki]

I am trying to add a conditional formula to calculate commission sales and I
keep coming up with #NAME?. The criteria I am working with are: if the
amount in cells B3 thru B8 are less than $1000 then the commission is paid
at 5%, if it is between $1000 and $3999.99 then the commission is paid at 10%
and if is above $4000 then the commission is paid at 12.5%. I am imputting
the formula in cells F3 thru F8. The formula I was using worked for some but
not for others. This is the function I was using:
IF(B3<1000,B3*5%,IF(B3BETWEEN1000,3999.99,B3*10%,IF(B3>4000,B3*12.5%))).
Please can someone tell me what I am doing wrong, I need help yesterday.....

 

[Bentam7]

I think the problem is that there is no function called BETWEEN. Try this:

=IF(B3<1000,B3*5%,IF(AND(B3>=1000,B3<4000),B3*10%,IF(B3>=4000,B3*12.5%)))

 

[T. Valko]

if it is between $1000 and $3999.99

if is above $4000

I guess you meant greater than or equal to 4000? Otherwise, those conditions
*exclude* 4000.

=IF(B3<1000,B3*5%,IF(B3<4000,B3*10%,B3*12.5%))