ExcelBanter - IF function limitation

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

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

- - IF function limitation (https://www.excelbanter.com/excel-worksheet-functions/445724-if-function-limitation.html)

Srinivas Sharma

IF function limitation

Hi,
I am unable to use the formula "IF(C2="GRK","GRK",IF(D2="LNG","LNG",IF(E2="SNS"," SNS",IF(F2="DVM","DVM",IF(G2="APK","APK",IF(H2="KC S","KCS",IF(I2="SWS","SWS",IF(J2="KLS","KLS",IF(K2 ="DVR","DVR",IF(L2="MJV","MJV"))))))))))" in Excel 2003 because of the limitations. Could anybody help me out of this.

All times are GMT +1. The time now is 10:57 AM.