+ Reply to Thread
Results 1 to 8 of 8

Nesting more than 7 If statement in excel 2007

Hybrid View

  1. #1
    Registered User
    Join Date
    04-18-2019
    Location
    Indonesia
    MS-Off Ver
    MS. Office 2007
    Posts
    2

    Nesting more than 7 If statement in excel 2007

    I wanna use this formula on Excel 2007, but i know excel 2007 only 7 levels if.
    how to solve this formula?
    thanks before

    =IF(AND(H4<>"";D8="store name");E8;IF(AND(H4<>"";D9="store name");E9;IF(AND(H4<>"";D10="store name");E10;IF(AND(H4<>"";D11="store name");E11;IF(AND(H4<>"";D12="store name");E12;IF(AND(H4<>"";D13="store name");E13;IF(AND(H4<>"";D14="store name");E14;IF(AND(H4<>"";D15="store name");E15;IF(AND(H4<>"";D16="store name");E16;IF(AND(H4<>"";D17="store name");17;IF(AND(H4<>"";D18="store name");E18;IF(AND(H4<>"";D19="store name");E19;IF(AND(H4<>"";D20="store name");E20;IF(AND(H4<>"";D21="store name");E21;IF(AND(H4<>"";D22="store name");E22;IF(AND(H4<>"";D23="store name");E23;IF(AND(H4<>"";D24="store name");E24;IF(AND(H4<>"";D25="store name");E25;""))))))))))))))))))

  2. #2
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Nesting more than 7 If statement in excel 2007

    If you can give a better description of what you're trying to do, we can offer better help. The best way to do so is to attach a sample workbook with an example of your data, an explanation of what you're trying to do, and the results you're expecting.

    To attach a workbook, click Go Advanced, then scroll down to Manage Attachments. Click Browse to find your file, click Open, and then click Upload. Finally, click Close this window. Your workbook will be attached when you submit your reply.

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.85 for Mac MS 365
    Posts
    8,519

    Re: Nesting more than 7 If statement in excel 2007

    have you tried your formula? As far as I know you can use up to 64 IF functions in excel 2007.
    https://support.office.com/en-us/art...5-4ef99da241c8
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Registered User
    Join Date
    04-18-2019
    Location
    Indonesia
    MS-Off Ver
    MS. Office 2007
    Posts
    2
    excel 2007 only up to 7 Levels,

  5. #5
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Nesting more than 7 If statement in excel 2007

    Kindly upload a sample sheet it helps

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    82,813

    Re: Nesting more than 7 If statement in excel 2007

    Provide the workbook as requested in post #2.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,915

    Re: Nesting more than 7 If statement in excel 2007

    Try below formula
    =IF(H4<>"";IFERROR(VLOOKUP("store name";$D$8:$E$25;2;0);"");"")
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  8. #8
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,504

    Re: Nesting more than 7 If statement in excel 2007

    To avoid using nest if, try VLOOKUP instead:

    =IF(H4="","",VLOOKUP("store name",D8:E25,2,0))
    Quang PT

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] help nesting OR statement into COUNTIFS statement
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-18-2014, 09:31 AM
  2. Nesting IF Statement
    By firehousetk in forum Excel General
    Replies: 8
    Last Post: 11-28-2011, 12:22 PM
  3. Excel IF Statement and nesting
    By angryromancegrrl in forum Excel General
    Replies: 3
    Last Post: 11-09-2010, 01:54 PM
  4. Recording a macro with 12 or more nesting formulas. Excel 2007
    By arjun_mail in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-30-2010, 12:38 AM
  5. Levels of Nesting 2003 vs 2007
    By simon.fish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-17-2010, 05:28 AM
  6. If statement nesting
    By msbing916 in forum Excel General
    Replies: 4
    Last Post: 05-07-2010, 03:38 PM
  7. Nesting Formulas in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-15-2007, 02:33 AM

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