IF Formula
try
=IF(D6="H","27",IF(D6="M","18",IF(D6="L","9",0)))
"Janessa" wrote:
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?
|