Any suggestions?

Don't use the space bar to clear B1. Text will cause an error with a
math operator.

Or else use something like

=IF(LEN(TRIM(B1))=0,D1,B1) - A1

In article ,
Debbie wrote:

Sounds good but it's giving me a VALUE error?