=IF(G4="",0,G4-A4)
--
Gary''s Student - gsnu200825


"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