+ Reply to Thread
Results 1 to 5 of 5

Multiple If statements (nested ifs ??)

  1. #1
    Forum Contributor ndtsteve's Avatar
    Join Date
    05-01-2012
    Location
    Guildford, Surrey, England
    MS-Off Ver
    365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit
    Posts
    110

    Multiple If statements (nested ifs ??)

    Please see below image, sample workbook attached:
    2022-08-09 17_48_59-Steve Help - Excel.png


    Trying to figure out how to make a cell say Yes or NO depending if value exceeds certain value (figured that bit) but remain blank if no value has been entered (don't get that bit!)
    Attached Files Attached Files
    Last edited by ndtsteve; 08-10-2022 at 11:19 PM. Reason: Marked as solved
    Thanks in advance.......Steve

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,498

    Re: Multiple If statements (nested ifs ??)

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Multiple If statements (nested ifs ??)

    Deleted, same as above.

  4. #4
    Forum Contributor ndtsteve's Avatar
    Join Date
    05-01-2012
    Location
    Guildford, Surrey, England
    MS-Off Ver
    365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit
    Posts
    110

    Re: Multiple If statements (nested ifs ??)

    Cheers TMS,
    Worked a treat, I'm sure I tried that............tried so many variations of "","" but I guess I must have just missed that one!

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,498

    Re: Multiple If statements (nested ifs ??)

    You're welcome. Thanks for the rep.

+ 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] Multiple nested IF statements
    By Natalie C in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 09-26-2021, 05:01 PM
  2. multiple/nested if then statements
    By StrugglewExcel in forum Excel General
    Replies: 5
    Last Post: 09-14-2015, 02:52 AM
  3. [SOLVED] Nested if statements containing multiple and statements
    By John M. in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2014, 11:48 PM
  4. Multiple Nested IF Statements
    By rlsublime in forum Excel General
    Replies: 1
    Last Post: 11-15-2012, 02:01 PM
  5. Multiple nested IF statements and AND statements
    By TonyGetz in forum Excel General
    Replies: 2
    Last Post: 12-14-2010, 03:07 AM
  6. Replies: 12
    Last Post: 05-15-2009, 08:38 AM
  7. [SOLVED] multiple nested IF statements
    By jazzydwit in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-29-2005, 01:30 PM

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