Thank you for the reference to lookup. I was able to research that and have
made it work. I really appreciate your response.

"Bill" wrote:

=(IF(K14=60210,"OF1130",IF(K14=60415,"OE1480",IF(K 14=60511,"OR1600",IF(K14=61211,"MF2000",IF(K14=612 40,"MF2040",IF(K14=61414,"ME2280",IF(K14=61511,"MR 2380"," "))))))))

I have 10 items in cell K14. I want to be able to extend the logic to 10
but Excel has a limit of 7 nested if's. I am not familiar with lookup tables
but will look into that.
Thank you

Bill


"Pete_UK" wrote:

Can you post an example of your formula with nested IFs and point out
how you want to extend it?

Often a lookup table can reduce a multiple-IF formula, but it depends
on exactly what you want to do.

Pete

Bill wrote:
I am able to utilize a logical IF to automatically select the data I want to
show in a cell based on the result of the logical IF statement. My problem
is that I want to exceed the apparent limit of 7 nested IF's. The result
must show up in a speciofic cell.
I could utilize several cells (on a different worksheet) to all reference
the data in a specific cell and then use a seperate cell to query the result
of the cells but that is where I get confused.