Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
Try
=IF(D6="H",27,IF(D6="M",18, IF(D6="L",9))) "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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
You need to quote your letters and not your numbers.
=IF(D6="H",27,IF(D6="M",18, IF(D6="L",9))) Regards, Paul "Janessa" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|