Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 01-19-2012, 11:57 AM
Jamal NUMAN Jamal NUMAN is offline Using if statement many times! Windows 7 64bit Using if statement many times! Office 2010 64bit
Expert
Using if statement many times!
 
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
File Type: jpg Clip_284.jpg (78.9 KB, 11 views)
File Type: jpg Clip_285.jpg (84.4 KB, 11 views)
Reply With Quote
 



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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft