I used your formula and did not have your problem.
If Q10 is blank, then from your formula, the results is "";
If E10 is blank, then it returns the date value of the date in Q10.
IF both are blank, it also returns "".
If you still have the problem, then try this:
= if(iserror(yourformula), "", yourformula)
replace yourformula in above with IF(Q101,Q10-E10,"")
--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - -
www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Clash" wrote in
message ...
Please help,
I am calculating the difference between two dates,
=IF(Q101,Q10-E10,"")
but if one of the cells is empty it's showing #VALUE!.
Is there a way to stop this happening.
Many thanks
--
Clash
------------------------------------------------------------------------
Clash's Profile:
http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=545642