Using if statement many times!

Catalin.B · #1 01-19-2012, 03:44 AM

Anyway, in a single cell you can use only 7 nested IF 's for all versions of excel.

Jamal NUMAN · #2 01-19-2012, 11:57 AM

Quote:

Originally Posted by Catalin.B

Anyway, in a single cell you can use only 7 nested IF 's for all versions of excel.

Thank you all for the informative answers. it is very helpful.

fortunately, i could replace the If statement with the VLookup which is much easier. the screenshots are attached

best

Jamal

Colin Legg · #3 01-19-2012, 12:05 PM

Quote:

Originally Posted by Catalin.B

Anyway, in a single cell you can use only 7 nested IF 's for all versions of excel.

Not in all versions - the limit was increased from 7 to 64 in Excel 2007. But using a look up of some description is definitely the preferred option here.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF Statement and Macros	kannon	Excel Programming	2	01-06-2012 02:51 AM
What IF statement required	dr4ke	Excel	8	09-01-2011 07:41 AM
Help with IF Statement	limpbizkit	Excel	4	02-24-2011 09:16 PM
if statement	piper7971	PowerPoint	1	08-19-2010 07:10 AM
Help with IF statement!	CPelkey	Word	1	04-12-2010 09:06 AM