Multiple String IF Formulas
Hi
=IF(C11="M",50,IF(C11="C",50,IF(C11="L",15,"")))
The final pair of double quotes signifies nothing to be entered in the cell
if the value in C11 is not C or M or L. Change to anything else you wish.
--
Regards
Roger Govier
"cwn" wrote in message
...
What is the format for a multiple-string IF formula? Here is what I am
trying to do:
IF(C11="M",50) IF(C11="C",50) IF(C11="L",15)
Thanks!
|