View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
adriver adriver is offline
external usenet poster
 
Posts: 3
Default #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!