"Barb Reinhardt" wrote in message
...

IF(AND(ISBLANK(C3)=FALSE,ISBLANK(D3)=FALSE),D3-C3,"")

Shorter to use:

=IF(COUNT(C3:D3)=2,D3-C3,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk