=if(b1="Paid",a1,if(b1="part",a1*0.75,a1*0.5)

Regards,
Fred.

"John DeLosa" wrote in message
...
I don't use these multi level formulas enough to remember how to set them
up.
. . here is what Id Like to do.


. A B C

1 $100 €œPaid€� $100

2 $100 €œpart€� $75

3 $100 €œhalf€� $50

I would like a formula in C1 that looks at B1 and if it is €œPaid€� then
A1*1
if it is €œpart€� then A1*0.75 and if it is €œhalf€� then A1*0.5

Please help I seem to be missing a ( ) some were when I do it . . . .
Thanks John D