| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE error with empty cells
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,"") -- David Biddulph "adriver" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| #Empty error | Excel Discussion (Misc queries) | |||
| remove error value when formula exists for empty cells | Excel Worksheet Functions | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Linear Mode
