| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Max number of IF statements
What is the max number of If statements you can use in a formula ?
Thanks, yosef |
|
#2
|
|||
|
|||
|
7 embedded IFs, which means you can have the word IF a total of 8 times.
************ Anne Troy www.OfficeArticles.com "ynissel" wrote in message ... What is the max number of If statements you can use in a formula ? Thanks, yosef |
|
#3
|
|||
|
|||
|
You can have 8 maximum nested if statements in 1.
-- Regards, Dave "ynissel" wrote: What is the max number of If statements you can use in a formula ? Thanks, yosef |
|
#4
|
|||
|
|||
|
You can have dozens of IF() statements, but they can only be nested 7
deep. For a workaround, see http://cpearson.com/excel/nested.htm OTOH, if you have to nest more than 4 or 5 deep, it's almost always easier to use an alternative method, e.g., Lookups, math operations, etc. In article , "ynissel" wrote: What is the max number of If statements you can use in a formula ? Thanks, yosef |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
| doubling a number X number of times | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| How do I sort a column a unique number? | Excel Worksheet Functions | |||
Linear Mode
