Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Run out of nested Ifs
Please can someone advise about the following problem.
I have a spreadsheet with 2 columns each with parallel data to which other cells need to refer eg 1 1.5 2 2.7 3 2.9 4 3.1 5 3.5 6 3.8 7 4.1 8 5.2 9 6.3 10 7.3 I also have a data entry cell where I can enter numbers from 1 to 10, and a result cell which needs a formula which automatically returns the data from column on the right to match that on the left. To put it simply, if I enter a 2 into the data cell I want to see 2.7 in the result cell; if I enter 7, I want to see a result of 4.1 I've managed to do this with a complicated set of nested IF calculations, but these run out at 7 nests, so I can't do this for all 10 sets of data. Is there a way of doing this? Thanks Clive |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exceeding the limit for Nested IFs | Excel Worksheet Functions | |||
Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions |