Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #13  
Old 11-15-2022, 11:59 PM
ArviLaanemets ArviLaanemets is offline Multiple If statements, Windows 8 Multiple If statements, Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by Jun39 View Post
You can nest up to 7 IF functions to create a complex IF THEN ELSE statement.
With some tweaking, you can increase this number in some degree. E.g. with 1st IF you divide conditions to 2 condition groups, and use 6 nested IF's for both of them. Something like
Code:
=IF(StartCondition,IF(...,...,IF(...,,IF(...,...,IF(...,...,IF(...,...,IF(...,...,...)))))),IF(...,...,IF(...,,IF(...,...,IF(...,...,IF(...,...,IF(...,...,...)))))))
This doesn't mean it will look pretty, or easy to follow up. Or that such formula will work with reasonable speed for big tables. But anyway, in such way you can instead 7 nested IF's use 2*6=12 IF's, or 4*5=20 IF's, or 8*4=32 IF's, or 16*3=48 IF's, or 32*2 = 64 IF's. The last number is theoretical maximum
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple If statements, Please tell me it doesn't take 7 statements to turn table borders off Jennifer Murphy Word VBA 5 07-25-2012 03:12 PM
Multiple If statements, showing results of If statements in a mail merge m&co Mail Merge 3 01-06-2012 07:27 PM
Multiple Input, Multiple Digital Signatures Jeff Word 0 01-04-2012 09:03 AM
Multiple task lists and multiple calendars kballing Outlook 0 01-18-2011 10:23 AM
IF statements that shifts to right. kent Excel 0 01-19-2006 02:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:26 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