TWO IF

[Guest]

i am trying to write formula to calculate the bonus.
if salesperson sells Queen mattress at or over $89.95, bonus=selling price
*10%, else 0;
if salesperson sells King mattress at or over 99.95, bonus=selling
price*10%, else 0.
My formula: if(and(a="Queen", b>="89.95"), selling price*10%, 0),
if(and(a="King", b>="99.95", selling price*10%, 0). but it does not run.
Please help. Tks in advance.
Sue

 

[John Michl]

Try this:

=IF(AND(A1="Queen",B1>=89.95),B1*0.1,IF(AND
(A1="King",B1>=99.95),B1*0.1,0))

You had quotes around the dollar amounts and the second if statement
should be the "false" result of the first statement. You've probably
thought about this but I would suggest not hard coding the dollar
amounts in the formula. Instead but those values in cells somewhere
and have the formular reference the cell. That way you can easily
change the amounts later on.

- John Michl
www.JohnMichl.com