View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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!