+ Reply to Thread
Results 1 to 3 of 3

levels of nesting

  1. #1
    Registered User
    Join Date
    11-01-2011
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    13

    levels of nesting

    hi i am trying to get this formula to work in excel 2010 :

    =IF(AO39>5500000, 350,IF(AO39>4800000, 300,IF(AO39>4000000, 250,IF(AO39>3200000, 200,IF(AO39>2400000, 160,IF(AO39>2000000, 130,IF(AO39>1500000, 100,IF(AO39>1250000, 80,IF(AO39>720000, 40,IF(AO39>400000, 20,IF(AO39>170000, 10,IF(AO39>60000, 2,))))))))))))

    but i get this message:

    the specified formula cannot be entered because it uses more levels of nesting than allowed in the current file format.

    Can some one help please

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: levels of nesting

    How about something like this, but more values
    =LOOKUP(AO39,{60000,17000,40000},{2,10,20})

    Note that the first array has to be sorted ascending.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    11-01-2011
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: levels of nesting

    thanks a lot it work a treat

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1