Microsoft Office Forums - View Single Post - Using if statement many times!

Thread: Using if statement many times!

View Single Post

Old

01-19-2012, 11:57 AM

Jamal NUMAN Jamal NUMAN is offline

Jamal NUMAN is offline

Jamal NUMAN uses Windows 7 64bit

Windows 7 64bit Jamal NUMAN uses Office 2010 64bit

Jamal NUMAN uses Office 2010 64bit

Office 2010 64bit

Expert

The original poster

Join Date: Nov 2010

Posts: 615

Jamal NUMAN is on a distinguished road

Thumbs up

Quote:

Originally Posted by Catalin.B

View Post

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

Attached Images

	Clip_284.jpg (78.9 KB, 11 views)
	Clip_285.jpg (84.4 KB, 11 views)

Reply With Quote