Assume you want your result in A1:
in A1 type your usual seven layer nested if statement, like so...
Notice that last argument "B1". In B1 you would write the continuation of your formula; the next seven layers. You can keep going like that unlimited. If you make the last argument in B1's formula "C1", then you can continue another set of layers in C1. Make sense? I'm not sure if I even made sense to myself.
There is another way where you can nest up to 28 "conditions" with a different command, but I'm going to have to take a look at one of my sheets first. I'll post it later...
Hope I helped some...
I've seen Cory's post, sure thing. I admit I argued at this bord more than once against nesting more than 3 IFs and proposed alternatives using VLOOKUP. If you wish to set up a formula containing 20 nested IFs and you're willing to debug such a formula when the need arises, please do so.
no....don't want that much difficulty!...my excel skills are limited at best...don't even know how to use vlookup....did the pearson web site make any sense to you?....I tried to use that tecnique, but it was over my head as well...not sure where I was supposed to enter all the various formulas...
I wish Pearson had removed that IF thing from his web site. Otherwise he has great collection of matters Excel. But, why not answer questions that I posed in my initial post regarding your problem?
thanx for the replies aladin
I have a medical spreadsheet with a column for procedures. Each of these has a corresponding numeric code that I would like to appear in the adjacent cell automatically...so that I do not have to type it in each time....there are about 2 dozen procedures, hence the problem with the 7 limit with nesting.
hope that is clearer. thanx again
Set up a 2-column table on a seaprate sheet like this:
Select the cells of this table, go to the Name Box, and type PROCEDURES and enter.
Now go the worksheet where you have all those procedures. Lets say that A1 is the first cell containing a procedure.
In B1 enter: =VLOOKUP(A1,PROCEDURES,2,0)
This formula retrieves the associated numeric code from PROCEDURES.
Note that this formula expects each procedure to be unique.
Copy down this formula as far as needed.
that did the trick..thanks....