Correcting an #VALUE! error message RRS feed

  • Question

  • I am attempting to do a excel spreadsheet that has blanks where the date/time is located. But the way the formula is written, it should put a zero as the result of the formula. Instead, I just get this #VALUE! in the location. The formula that I am applying is: =IF(S1-G1<0,"0",S1-G1)

    • Moved by Dave PatrickMVP Thursday, August 2, 2018 1:49 PM not a forums suggestion issue
    Thursday, August 2, 2018 1:46 PM