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

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

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

*VLOOKUP* is usually a good alternative (in most cases).

Regards.


--
BenjieLop


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

Depending on your situation, you may be able to use one of the more
typical "workarounds".....a lookup table.

Example:
If you want your formula to return a department name based on its
DeptID, as in ...
IF A1=101, Return "A/R"
IF A1=102, Return "Shipping"
IF A1=103, Return "Maintenance"
IF A1=104, Return "Finance"
IF A1=105, Return "Security"
IF A1=106, Return "Tax"
IF A1=107, Return "Systems"
IF A1=108, Return "Treasury"
IF A1=109, Return "Admin"

You'd create a list (probably on another worksheet, say Sheet2) like
this:

ROW____COL_A_________COL_B
1_______101___________A/R
2_______102___________Shipping
3_______103___________Maintenance
4_______104___________Finance
5_______105___________Security
6_______106___________Tax
7_______107___________Systems
8_______108___________Treasury
9_______109___________Admin

Now, on Sheet 1:
A1: 106
B1: =VLOOKUP(A1,Sheet2!A1:B9,2,0)
(returns the value that corresponds to DeptID 106--Tax)

Something you could use? Or is your situation more complicated?

Regards,
Ron


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