ExcelBanter - IF Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Formula (https://www.excelbanter.com/excel-discussion-misc-queries/142992-if-formula.html)

Janessa

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?

AKphidelt

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?

PCLIVE

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?

Nikki

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?

All times are GMT +1. The time now is 04:29 PM.