View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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!