Results 1 to 5 of 5

#value

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2015
    Location
    South Carolina
    MS-Off Ver
    2013
    Posts
    13

    #value

    I have the following if statement: =IF((E10-D10)>=0,(E10-D10),"")
    This formula means that if the subtraction of the 2 numbers is negative than it will be a blank cell. However, the cell E10 shows: "#VALUE!" because one of the cells it refers to in its formula doesn't have a number yet.
    I want my IF statement to show a blank cell if E10 = "#VALUE!".
    I hope this makes sense...

    HELP!
    Thanks
    Last edited by kwrigh6; 07-15-2015 at 07:43 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