if statement limit??

[_Bigred]

Is there a way around the if statement limit???

TIA,
_Bigred

 

[Biff]

It all depends, but the answer is probably yes!

You can't "extend" the 7 nested function limit but there
are other methods you could employe.

Biff

 

[_Bigred]

Does anyone actually have a method to get around the 7 nest limit. I am
trying to run a if statement but in reality it will contain probably 10-12
if's (too big for if statement).

any resources or thoughts would be greatly appreciated,
_Bigred

 

[Harlan Grove]

Does anyone actually have a method to get around the 7 nest limit. I am
trying to run a if statement but in reality it will contain probably 10-12
if's (too big for if statement).

...

Since you're unwilling to provide any details of what you're trying to do, vague
generalities are all we can give in response. CHOOSE and VLOOKUP would be the
most likely alternatives. As for resources, search for 'nested' in *excel*
newsgroups from Google Groups Advanced Search,

http://www.google.com/advanced_group_search?hl=en

 

[_Bigred]

ultimately i am trying to calculate some contract raise values (for 5,600
employees).

if they are 15-17 out of 56 job classifications they will get specific
market (value) adjustments + %'s. All others would get only the %'s raises.

I would like to be able to use a formula (even using hidden columns) that
will do if

Person Classification HrlyWage
Reclass Yr1Raise (1%) Yr2Raise
John Doe Safety Inspector $22.00
$1.50 $? $?
Jane Doe Meat Inspector-Dev $13.74 $2.55
$? $?

there are more the above is just a example of the type of data I would like
to calculate.
Hope this helps,
_Bigred

 

[Harlan Grove]

ultimately i am trying to calculate some contract raise values (for 5,600
employees).

if they are 15-17 out of 56 job classifications they will get specific
market (value) adjustments + %'s. All others would get only the %'s raises.

...

Enter a table of job classifications, market adjustments and %s. So 3 columns by
56 rows. For the job classifications not getting market adjustments, either
leave the cells in the market adjustment column blank or enter zero. Then use
VLOOKUP to pull the market adjustment and % from that table using each
employee's job classification as the 1st argument, the range address of this
created table as 2nd argument, 2 or 3 as 3rd argument for market adjustment and
%, respectively, and 4th argument 0 (zero).