Excel only allows 7 nested If statements, is there a way around this?
Excel only allows 7 nested If statements, is there a way around this?
VLOOKUP is usually a good alternative (in most cases).Originally Posted by jgannon
Regards.
BenjieLop
Houston, TX
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
>
>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks