How do I enter a function that has more than 7 nested functions

T

Tkokkine

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!!!
 
B

Bob Phillips

=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)
 
C

ChristopherTri

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top