Thread: IF Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janessa Janessa is offline
external usenet poster
 
Posts: 4
Default IF Formula

I am getting error messages for this:

=IF(D6=H,"27",IF(D6=M,"18", IF(D6=L,"9")))

I am trying to assign a value to a certain letter (High, Medium, Low). Is
this the wrong formula, or where do I need to make changes?