ExcelBanter - IF Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Function (https://www.excelbanter.com/excel-worksheet-functions/93165-if-function.html)

hobscons

IF Function

How many nested IF's can you have as arguments in that function?

Dave

IF Function

I believe that the limit is 7.

Dave

"hobscons" wrote in message
...
How many nested IF's can you have as arguments in that function?

Joe Mac

IF Function

As extracted from the on-line help utility...

Up to seven IF functions can be nested as value_if_true and value_if_false
arguments to construct more elaborate tests.
--
Hope it helps -
Joe Mac

"hobscons" wrote:

How many nested IF's can you have as arguments in that function?

All times are GMT +1. The time now is 09:47 AM.