#VALUE error with empty cells
I am building a log that calculates the amount of time between a doc is
received, and when it is finished with review. When the "date in" and "date
out" cells are populated, the calculation works fine, but when both cells are
empty, a #VALUE error is returned, and the boss hates it. Based on a prior
thread here I've tried
=IF(OR(F2="",R2=""),"",SUM(F2-R2)) but it's not working out.
Please help!
|