Results 1 to 4 of 4

IF Statemet returning error (#VALUE!) [Subtracting from ""]

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2010
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    47

    Post IF Statemet returning error (#VALUE!) [Subtracting from ""]

    Hi,

    the following 'if' statement returns a #VALUE! error if the target cells have no value:

    =IF(G19-H19<0,G19-H19,"")
    Here's what I tried to fix it, which was not successful.

    =IF(G19="",IF(H19="","",IF(G19-H19>0,G19-H19,"")),IF(G19-H19>0,G19-H19,""))
    I understand that subtracting a "" value doesn't make any logical sense to excel, but is there a way to get excel to 'think' that these "" values represent 0?
    Last edited by Shane O; 02-21-2011 at 04:17 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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