Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(AND(. . . ????
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 |