Multiple String IF Formulas
 

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!

Multiple String IF Formulas
 

IF(C11="M",50,IF(C11="C",50,IF(C11="L",15,"somethi ngelse")))


"cwn" wrote:

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!

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!

Multiple String IF Formulas
 

Try this:

=MAX(COUNTIF(C11,{"M","C","L"})*{50,50,15})

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"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!

Multiple String IF Formulas
 

=IF(OR(C11="M",C11="C"),50,IF(C11="L",15,"?"))
You did not state what to return if C11 is not M, C or L so I return a ? in
that case.

Tyro
"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!