Thread: Multiple String IF Formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Jim is offline
external usenet poster
  
Posts: 615
Default 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!
Reply With QuoteReply With Quote