ISBLANK IF STATEMENT

[PDUB]

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

 

[Harlan Grove]

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

if G4 would always be greater than A4 when G4 isn't blank,

=max(G4-A4,0)

 

[Gary''s Student]

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

 

[David Biddulph]

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) ?

 

[xlmate]

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]

That worked beautifully!
Thank You!
--
PDUB

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]

I'm sorry I was working with the ISBLANK and forgot to click it off.
--
PDUB

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

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

 

[xlmate]

You're welcome, glad that it work for you.
Thank you for your feedback.


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

Thank You

cheers, francis