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

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

Hope this helps:

=IF(AND(ISNUMBER(Q10),ISNUMBER(E10),Q101),Q10-E10,"")

ed

Do you have formulas in E10 and Q10?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=545642

daddylonglegs Wrote:
Do you have formulas in E10 and Q10?

Sorry I didn't say.

Yes, they are to formulas, the two dates are pulled thru from two
different spreadsheets.


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=545642