Nested IF statements drive me crazy.. Win Excel vs MAC Excel 1

[ladyck3]

I'm trying to help my daughter and I'm stuck, nested IF statements just bring me to my knees... I swear.
I'm wondering if "IF" statements used in the Win Version work the same on on a MAC Excel worksheet.

Cell References for the formula are:

COMMISSION is in Cell B55 and this is where the formula will reside.

What I'm trying to do is this:

1. if Overhead (F33) is 40% or more, commission = Selling price*10% (G37)
2. If overhead (F33) is 39% or lower, commission = Profit*33% (G36)

Its plain and simple I believe a matter of if F33 >= .4 *.01 / if F33 is <.4 *.033

For the life of me I get the same error and its one I never saw before (I wish I could paste a screen shot)

The formula typed contains an error
For information about fixing common formula problems,, Click Help.
To get assistance in entering a function, click Function Wizard (Formulas tab, Function Library group).
If you are not trying to enter a formula, avoid using an equal sign or minus sign to precede it with a single quotation mark.
Thanks in advance

I know its after hours but I sure hope someone is listening

Laurie


ladyck3
aka: Laurie

 

[mintjulep]

Something is either greater than 40 or not. No need for more than one test. No need to nest.

=if(F33>=0.4,0.1*G37,0.33*G36)

 

[ladyck3]

Thanks Mintjulep...

AWESOME Solution... works like a charm and I learned something or was reminded and my daughter is a happy camper
I wish she'd give me some time to teach her vlookup and Pivot tables

She doesn't want to work on the weekend... ITS NOT WORK ITS FUN
I'll wrangle her in sooner or later

WIsh I could give you more than 1 star

Laurie

ladyck3
aka: Laurie

 

[lionelhill]

Just a brief extra:
(1) If asked to do something more complicated, involving more than two different commissions, resulting from more than one threshold overhead, an easy way to do it is to avoid if()s altogether, and instead put in a table of overheads and corresponding commissions, and then use lookup() to find the appropriate commission.
(2) mintjulep's solution also saves you the embarrassment of wondering what to do if the overhead was 39.5%.