Without more information, (Like exactly what are you trying to do that you
need more than seven nested if statements?) I can't help you. BUT you might
try spreading out your function over more than one column, such that the
output of one function gives an incomplete result, which is completed by the
formula next to it.
--
Anne Murray


"jgannon" wrote:


Excel only allows 7 nested If statements, is there a way around this?


--
jgannon
------------------------------------------------------------------------
jgannon's Profile: http://www.excelforum.com/member.php...o&userid=29003
View this thread: http://www.excelforum.com/showthread...hreadid=487455