A cell in Excel contains 8 or 9 IF statements. The cell is returning
#VALUE error; meaning there is a flaw in the formula. Is there a way
to determine which part of the formula is being caculated without
having to go through each IF statement one-by-one? I hope my question
is clear. Any help would be great. Thanks.


--
maacmaac
------------------------------------------------------------------------
maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959
View this thread: http://www.excelforum.com/showthread...hreadid=504193

Maximum number of "IF" statements is 7.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=504193

You can get around that limitation. The following webpage shows how
using defined names.
http://www.cpearson.com/excel/nested.htm



wjohnson wrote:
Maximum number of "IF" statements is 7.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=504193

What's your formula?

Often if you're using multiple IFs there's a cleaner way with a LOOKUP
function or similar


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=504193