| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exceeding the limit for Nested IFs
I know there are other messages about nested ifs and the limit Excel places
(7), but none of them really apply. Here is what I need: Here is the function I have now using the limit and using multiple sheets (PB being the sheet I reference....I just need a way to use a function that will get me the same results...but using more "nested ifs", if you will. Here it is.... =IF($B$3=PB!$A$1,PB!B1,IF($B$3=PB!$A$2,PB!B2,IF($B $3=PB!$A$3,PB!B3,IF($B$3=PB!$A$4,PB!B4,IF($B$3=PB! $A$5,PB!B5,IF($B$3=PB!$A$6,PB!B6,IF($B$3=PB!$A$7,P B!B7,IF($B$3=PB!$A$8,PB!B8)))))))) PLEASE HELP!!! THANKS. -- Brad |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum limit and marking | Excel Worksheet Functions | |||
| Is there a limit to number of successive IF-THEN statements? | Excel Discussion (Misc queries) | |||
| Make the row limit of excel flexible -not fixed at 65536. | Excel Discussion (Misc queries) | |||
| Limit to the number of items in a cell | Excel Worksheet Functions | |||
| How do I add a limit line to a chart, so I can see where a data p. | Charts and Charting in Excel | |||
Threaded Mode
