Results 1 to 3 of 3

How to get IF statement not to include Null cells?

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

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