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