Force unused formula cells to be null

[Larry R]

It has several columns, "F" START DATE, "G" END DATE, "H" CONTRACT DAYS. H
column has the formula =G4-F4+1 this gives me the amount of contract days.
Column "J" has the formula =G4-(TODAY()) this gives the number of contract
days past. My problem is on the lines that do not have data yet show 0 in
the fields that contain the different formulas. How can I force the formula
cells to be NULL?



I appreciate any help.

Larry R.

 

[Pete_UK]

Like this:

H4: =IF(OR(G4="",F4=""),"",G4-F4+1)

J4: =IF(G4="","",G4-TODAY())

Copy down as far as you want to.

Hope this helps.

Pete

 

[Larry R]

Pete, it works great, but when I have a contract that has not started yet, I
get the amount of days between G and J, I guess J needs to be null too if
the contract has not started yet. I have spent a whole day trying to get
were you got me in a few minutes.



Thank you for your help.

Larry



Like this:

H4: =IF(OR(G4="",F4=""),"",G4-F4+1)

J4: =IF(G4="","",G4-TODAY())

Copy down as far as you want to.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Larry - glad to be of help.

Pete

 

[Gord Dibben]

Larry

Just note that "" is not NULL

"" makes the cell look blank only.


Gord Dibben MS Excel MVP