If function

cutyfurby · Jun 29, 2006

Can i use the "if" function more than 7 times? if yes, how can i do
that?

Guest · Jun 29, 2006

Take a look here:

http://www.cpearson.com/excel/nested.htm

Gord Dibben · Jun 29, 2006

7 is the limit.

See Chip Pearson's site on "nested functions".

http://www.cpearson.com/excel/nested.htm

You may be better off using a VLOOKUP table.

Gord Dibben MS Excel MVP

Nesting Functions	4	Mar 16, 2009
Use of IF function	4	Jun 15, 2006
Multiple logic tests	0	Feb 3, 2015
I WANT TO USE =IF(AND(),IF(AND(),IF(AND()).	5	Jan 27, 2009
Count entries in the column translating to minutes.	5	Dec 27, 2014
Conditional Formatting based on active Named Range; IF Function to VBA	1	Dec 1, 2011
How can use IF function more than 7 times in a cell	4	Nov 13, 2004
want to track time while paste value in multiple column of same roe	1	Jun 15, 2014

If function

cutyfurby

Guest

Gord Dibben

Ask a Question

Similar Threads