ExcelBanter - IF Statement

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Statement (https://www.excelbanter.com/excel-discussion-misc-queries/78158-if-statement.html)

Kopel

IF Statement

How many "IF" statement can I nest in Excel?

Thank you.

Kopel

--
Kopel
------------------------------------------------------------------------
Kopel's Profile: http://www.excelforum.com/member.php...o&userid=32584
View this thread: http://www.excelforum.com/showthread...hreadid=523822

Sethnstorm

IF Statement

I don't remember specifically, but for some reason I remember 11 as the
maximum number of nested if statements allowed.

--
Sethnstorm
------------------------------------------------------------------------
Sethnstorm's Profile: http://www.excelforum.com/member.php...o&userid=22571
View this thread: http://www.excelforum.com/showthread...hreadid=523822

Peo Sjoblom

IF Statement

7

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

"Kopel" wrote in
message ...

How many "IF" statement can I nest in Excel?

Thank you.

Kopel

--
Kopel
------------------------------------------------------------------------
Kopel's Profile:
http://www.excelforum.com/member.php...o&userid=32584
View this thread: http://www.excelforum.com/showthread...hreadid=523822

All times are GMT +1. The time now is 10:01 PM.