Posted to microsoft.public.excel.misc

external usenet poster

Posts: 3,101

Nested IF error

Might help if you could provide more info

"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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3 nested IFs causes error	Bob	Excel Worksheet Functions	6	January 29th 07 07:43 PM
Nested subtotal display error	phil	Excel Discussion (Misc queries)	3	October 24th 06 09:16 AM
nested if statement returns #value error	[email protected]	Excel Discussion (Misc queries)	3	August 10th 06 04:27 PM
If and nested Sumif error	Joco	Excel Worksheet Functions	4	July 22nd 06 07:25 PM
Nested IF error	Ricardo Monteiro :^)	Excel Worksheet Functions	10	February 5th 06 08:40 PM

All times are GMT +1. The time now is 03:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us