ISBLANK IF STATEMENT
Firstly, please get your caps lock key repaired so that you can stop
SHOUTING.
Secondly, you seem to have lost part of your SUM formula. You have given
the SUM function only one argument (G4-A4), and not told it what other
arguments you want to sum with it. If you want just G4-A4, the formula is
=G4-A4 and you don't need the SUM function. [If you want to know how to use
the SUM function, look it up in Excel help.]
Perhaps what you want is =IF(G4="",0,G4-A4) ?
--
David Biddulph
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
|