=IF(AND(. . . ????
hi
=if(B1="Paid",A1,IF(B1="part",A1*.75,if(B1="half", B1*.5,0)))
or if you only have 3 possible options then
=if(B1="Paid",A1,IF(B1="part",A1*.75 ,B1*.5))
regards
FSt1
"John DeLosa" wrote:
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
|