You Ask! We Count!

Number of Nested If Statements in Excel

How many nested IF statements does Excel support?

64.

According to the Microsoft website, the latest version of Excel (Excel 2007) supports at most 64 nested IF statements, whereas Excel 2003 supports only 7. Nesting IF statements enables more complex actions; the IF function is built by defining a condition as well as values for each possible return: true or false. This function must be written following a specific syntax: IF(logical_test, value_if_true, [value_if_false]).

This fact is verified on : May 6, 2010.





Tagged as: , , , , ,

Leave a Response