Nested IF Function Will Not Return Other Values

[Maureen]

I have written the following Nested IF function
=IF(K13="N","NA",IF(K13="1","A",IF(K13="2","B",IF(K13="3","C",IF(K13="4","D")))))

However, once applied, only the 1st value "NA" is returned when the
condition is "TRUE". All other results return a value of "FALSE".

How do I rectify so that the other values appear when the condition is met?

 

[KARL DEWEY]

Try this --
=IIF(K13="N","NA",IIF(K13="1","A",IIF(K13="2","B",IIF(K13="3","C",IIF(K13="4","D")))))

 

[John Spencer]

Try asking this in an EXCEL forum for a better answer.

I would try changing the expression a bit (this is a GUESS).

=IF(K13="N","NA",IF(K13=1,"A",IF(K13=2,"B",IF(K13=3,"C",IF(K13=4,"D")))))

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================