=IF(AND(. . . ????
=IF(B1="Paid",A1,IF(B1="Part",A1*0.75,IF(B1="Half" ,A1*0.5,"")))
--
Regards,
Peo Sjoblom
"John DeLosa" wrote in message
...
I don't use these multi level formulas enough to remember how to set them
up.
. . here is what I'd 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
|