IF Formula

J

Janessa

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?
 
P

PCLIVE

You need to quote your letters and not your numbers.

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

Regards,
Paul
 
Top