+ Reply to Thread
Results 1 to 3 of 3

How to get IF statement not to include Null cells?

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

    How to get IF statement not to include Null cells?

    Good morning

    I have the IF formula that you see below that sort of works… there are some cases where cell H18 will be Null so I don’t want “Stale” comment to be returned if the cell is Null. I don’t know what to add to what I have so it won’t count it….

    Formula: copy to clipboard
    IF(H8<TODAY()-365,"Stale",IF(H14<TODAY()-365,"Stale",IF(H18<TODAY()-365,"Stale","")))
    Last edited by jgomez; 08-23-2012 at 10:49 AM.

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: How to get IF statement not to include Null cells?

    IF(AND(H18<TODAY()-365,H18<>""),"Stale","")
    Gary's Student

  3. #3
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

    Re: How to get IF statement not to include Null cells?

    Thank you sir!

+ 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