Conditional Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nikki - 26 Mar 2008 04:15 GMT

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.....:(

Signature

Thanks, Your help is really appreciated

Nikki

Reply to this Message

Bentam7 - 26 Mar 2008 04:26 GMT

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

> 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
[quoted text clipped - 5 lines]
> 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.....:(

Reply to this Message

T. Valko - 26 Mar 2008 04:30 GMT

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

Signature

Biff
Microsoft Excel MVP

>I am trying to add a conditional formula to calculate commission sales and
>I
[quoted text clipped - 10 lines]
> Please can someone tell me what I am doing wrong, I need help
> yesterday.....:(

Reply to this Message