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 a 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%,I F(B34000,B3*12.5%))).
Please can someone tell me what I am doing wrong, I need help yesterday.....:(
--
Thanks, Your help is really appreciated

Nikki

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%)))


"nikki" wrote:

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 a 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%,I F(B34000,B3*12.5%))).
Please can someone tell me what I am doing wrong, I need help yesterday.....:(
--
Thanks, Your help is really appreciated

Nikki

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%))


--
Biff
Microsoft Excel MVP


"nikki" wrote in message
...
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 a 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%,I F(B34000,B3*12.5%))).
Please can someone tell me what I am doing wrong, I need help
yesterday.....:(
--
Thanks, Your help is really appreciated

Nikki