ExcelBanter - If functions with Text << Response to Karen

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If functions with Text << Response to Karen (https://www.excelbanter.com/excel-worksheet-functions/9661-if-functions-text-%3C%3C-response-karen.html)

SUB-ZERO

If functions with Text << Response to Karen

Hi Karen,

Try this ...

=IF(A1="YNNNYYNN","ClassA",IF(A1="NNYYYNNN","Class B",IF(A1="NNNNNNNY","ClassB","")))

SUB-ZERO

--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

All times are GMT +1. The time now is 01:42 PM.