J
John DeLosa
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
.. . 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