#VALUE error with empty cells

A

adriver

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!
 
D

David Biddulph

To start with, you don't need SUM(); SUM(F2-R2) gives exactly the same as
F2-R2.

If you are getting a #VALUE error the cells are presumably not empty, but
contain strings (perhaps just spaces?).
You might want to try
=IF(COUNT(F2,R2)=2,F2-R2,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Persistent "Formula refers to empty cells" error despite cells evidently NOT being em 2
Adding cells until they are greater than a lookup cell and returning a value 1
b;ank cells in calculations 2
#VALUE error which disappears when I use F2, ENTER 1
Get "AVERAGE" function to ignore empty cells 6
IF - how to avoid cells with no value 6
Conditional Formatting 0
error message "#VALUE!" due to blank cells 3

Top