Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 11-15-2022, 08:46 AM
Juna93 Juna93 is offline Multiple If statements, Windows 11 Multiple If statements, Office 2021
Novice
 
Join Date: Nov 2022
Posts: 4
Juna93 is on a distinguished road
Default

As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet. It is possible to nest multiple IF functions within one Excel formula to get Excel with 4 outcomes. You can nest up to 7 IF functions to create a complex IF THEN ELSE statement.
Reply With Quote
  #17  
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: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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
Reply

Thread Tools
Display Modes


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 01:36 PM.


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