If function
 

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


--
cutyfurby
------------------------------------------------------------------------
cutyfurby's Profile: http://www.excelforum.com/member.php...o&userid=32371
View this thread: http://www.excelforum.com/showthread...hreadid=556942

If function
 

Take a look he

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

"cutyfurby" wrote:


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


--
cutyfurby
------------------------------------------------------------------------
cutyfurby's Profile: http://www.excelforum.com/member.php...o&userid=32371
View this thread: http://www.excelforum.com/showthread...hreadid=556942

If function
 

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

On Thu, 29 Jun 2006 09:54:59 -0500, cutyfurby
wrote:


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