ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Nested IF error (https://www.excelbanter.com/excel-discussion-misc-queries/136382-re-nested-if-error.html)

Greg Wilson

Nested IF error
 
You have answers to your post in the worksheet function ng. What is your
response to bj's suggestion?

Greg Wilson

"kd" wrote:

Hi,
Any help in the error below would be greatly appreciated.

=if(L2="I",if(L2="R","B",IF(L2="F","Ro",if(L2="SCA ","Ri",if(or(S2="IA",N2="GBS"),"GN",if(AND(L2="HC" ,or(N2="Fi",N2="In",N2="XC")),"OM",if(OR(N2="Ex",S 2<"IA"),N2="COS",N2="CO",S2="L"),"D","W")))))))

Thanks in advance.
KD



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com