try

=IF(ISBLANK(G4),0,G4-A4)

Does this do what you want?
If not, post back

HTH
--
If this posting is helpful, appreciate that you click on the Yes button below

Thank You

cheers, francis



"PDUB" wrote:

I HAVE A FIELD THAT CALCULATES THE AVERAGE DAYS TAKEN TO SEND CORRESPONDANCE.
THE FORMULA IN THIS CELL( H4) IS =SUM(G4-A4) THE PROBLEM IS THAT IF THERE IS
NO VALUE IN CELL (G4) THE VALUE RETURNED TO (H4) IS -39818. IS THERE A WAY TO
GET (H4) TO RETURN A VALUE OF ZERO (0)IF G4 IS EMPTY