if statement limit??

  • Thread starter Thread starter _Bigred
  • Start date Start date
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
 
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
 
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).
Click to expand...
...

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
 
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
 
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.
Click to expand...
...

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).
 
Back
Top