excel if blank put a zero?
I am using =(C5-B5) to give the total between two different dates.
Request \ Completed \ total
Ex: 3/26/2013 - 3/29/2013 = 3 days
But if I don't have a completed date yet an error shows...how do I keep that completed date forum blank or zero?
Answers & Comments
Verified answer
=IF(B5="", 0, C5-B5) will be result in a 0 if B5 is blank, otherwise the cell output will be C5-B5.
2 different ways to work with this would be
=IF(ISNUMBER(B5),C5-B5,0)
or you could try =IFERROR(C5-B5,0)
hope that helps