Correcting an #VALUE! error message

• Question

• 

  

  0

  Sign in to vote

  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