| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter a function that has more than 7 nested functions
I cannot figure out how to enter this function in excel:
=IF(L20='T-Mobile Rate and Device Prices'!$A$116,'T-Mobile Rate and Device Prices'!$B$116,IF(L20='T-Mobile Rate and Device Prices'!$A$117,'T-Mobile Rate and Device Prices'!$B$117,IF(L20='T-Mobile Rate and Device Prices'!$A$118,'T- Mobile Rate and Device Prices'!$B$118,IF(L20='T-Mobile Rate and Device Prices'!$A$119,'T-Mobile Rate and Device Prices'!$B$119,IF(L20='T-Mobile Rate and Device Prices'!$A$120,'T-Mobile Rate and Device Prices'!$B$120,IF(L20='T- Mobile Rate and Device Prices'!$A$121,'T-Mobile Rate and Device Prices'!$B $121,IF(L20='T-Mobile Rate and Device Prices'!$A$122,'T-Mobile Rate and Device Prices'!$B$122,IF(L20='T-Mobile Rate and Device Prices'!$A$123,'T- Mobile Rate and Device Prices'!$B$123,IF(L20='T-Mobile Rate and Device Prices'!$A$124,'T-Mobile Rate and Device Prices'!$B$124,IF(L20='T-Mobile Rate and Device Prices'!$A$125,'T-Mobile Rate and Device Prices'!$B$125,IF(L20='T- Mobile Rate and Device Prices'!$A$126,'T-Mobile Rate and Device Prices'!$B $126," ")))))))) Please help!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a function that has more than 7 nested functions
=IF(ISNUMBER(MATCH(L20,'T-Mobile Rate and Device Prices'!$A$116:$A$126,0)),
INDEX('T-Mobile Rate and Device Prices'!$B$116:$B$126,MATCH(L20,'T-Mobile Rate and Device Prices'!$A$116:$A$126,0)),"") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Tkokkine" <u26382@uwe wrote in message news:6601fcac08f0d@uwe... I cannot figure out how to enter this function in excel: =IF(L20='T-Mobile Rate and Device Prices'!$A$116,'T-Mobile Rate and Device Prices'!$B$116,IF(L20='T-Mobile Rate and Device Prices'!$A$117,'T-Mobile Rate and Device Prices'!$B$117,IF(L20='T-Mobile Rate and Device Prices'!$A$118,'T- Mobile Rate and Device Prices'!$B$118,IF(L20='T-Mobile Rate and Device Prices'!$A$119,'T-Mobile Rate and Device Prices'!$B$119,IF(L20='T-Mobile Rate and Device Prices'!$A$120,'T-Mobile Rate and Device Prices'!$B$120,IF(L20='T- Mobile Rate and Device Prices'!$A$121,'T-Mobile Rate and Device Prices'!$B $121,IF(L20='T-Mobile Rate and Device Prices'!$A$122,'T-Mobile Rate and Device Prices'!$B$122,IF(L20='T-Mobile Rate and Device Prices'!$A$123,'T- Mobile Rate and Device Prices'!$B$123,IF(L20='T-Mobile Rate and Device Prices'!$A$124,'T-Mobile Rate and Device Prices'!$B$124,IF(L20='T-Mobile Rate and Device Prices'!$A$125,'T-Mobile Rate and Device Prices'!$B$125,IF(L20='T- Mobile Rate and Device Prices'!$A$126,'T-Mobile Rate and Device Prices'!$B $126," ")))))))) Please help!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a function that has more than 7 nested functions
Set up a table, then use VLOOKUP function
-------------- mama no teeth "Tkokkine" wrote: I cannot figure out how to enter this function in excel: =IF(L20='T-Mobile Rate and Device Prices'!$A$116,'T-Mobile Rate and Device Prices'!$B$116,IF(L20='T-Mobile Rate and Device Prices'!$A$117,'T-Mobile Rate and Device Prices'!$B$117,IF(L20='T-Mobile Rate and Device Prices'!$A$118,'T- Mobile Rate and Device Prices'!$B$118,IF(L20='T-Mobile Rate and Device Prices'!$A$119,'T-Mobile Rate and Device Prices'!$B$119,IF(L20='T-Mobile Rate and Device Prices'!$A$120,'T-Mobile Rate and Device Prices'!$B$120,IF(L20='T- Mobile Rate and Device Prices'!$A$121,'T-Mobile Rate and Device Prices'!$B $121,IF(L20='T-Mobile Rate and Device Prices'!$A$122,'T-Mobile Rate and Device Prices'!$B$122,IF(L20='T-Mobile Rate and Device Prices'!$A$123,'T- Mobile Rate and Device Prices'!$B$123,IF(L20='T-Mobile Rate and Device Prices'!$A$124,'T-Mobile Rate and Device Prices'!$B$124,IF(L20='T-Mobile Rate and Device Prices'!$A$125,'T-Mobile Rate and Device Prices'!$B$125,IF(L20='T- Mobile Rate and Device Prices'!$A$126,'T-Mobile Rate and Device Prices'!$B $126," ")))))))) Please help!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I enter a function that has more than 7 nested functions
Since your data is already in table form, save some key strokes and use the
following: =VLOOKUP(L20,'T-Mobile Rate and Device Prices'!A116:B126,2) Regards... "Tkokkine" wrote: I cannot figure out how to enter this function in excel: =IF(L20='T-Mobile Rate and Device Prices'!$A$116,'T-Mobile Rate and Device Prices'!$B$116,IF(L20='T-Mobile Rate and Device Prices'!$A$117,'T-Mobile Rate and Device Prices'!$B$117,IF(L20='T-Mobile Rate and Device Prices'!$A$118,'T- Mobile Rate and Device Prices'!$B$118,IF(L20='T-Mobile Rate and Device Prices'!$A$119,'T-Mobile Rate and Device Prices'!$B$119,IF(L20='T-Mobile Rate and Device Prices'!$A$120,'T-Mobile Rate and Device Prices'!$B$120,IF(L20='T- Mobile Rate and Device Prices'!$A$121,'T-Mobile Rate and Device Prices'!$B $121,IF(L20='T-Mobile Rate and Device Prices'!$A$122,'T-Mobile Rate and Device Prices'!$B$122,IF(L20='T-Mobile Rate and Device Prices'!$A$123,'T- Mobile Rate and Device Prices'!$B$123,IF(L20='T-Mobile Rate and Device Prices'!$A$124,'T-Mobile Rate and Device Prices'!$B$124,IF(L20='T-Mobile Rate and Device Prices'!$A$125,'T-Mobile Rate and Device Prices'!$B$125,IF(L20='T- Mobile Rate and Device Prices'!$A$126,'T-Mobile Rate and Device Prices'!$B $126," ")))))))) Please help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF Function and VLookup Alternatives | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| I can't enter CSE functions | Excel Discussion (Misc queries) | |||
| ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
