If cellA is blank or 0 then cellB is blank

[~Natasha~]

I need your help again, I am still learning excel with a few bumps, her
is one of them.


=+E18+120

This is the formula I have in cell G18, E18 is a date, if E18 is lef
blank or 0, I want G18 to be blank.

The end result I want G18 to read 120 days from the date in E18, if E1
has no date, G18 should be blank.

Thank you!
Natash

 

[Aladin Akyurek]

=IF(ISNUMBER(E18),E18+120,"")

I need your help again, I am still learning excel with a few bumps, here
is one of them.


=+E18+120

This is the formula I have in cell G18, E18 is a date, if E18 is left
blank or 0, I want G18 to be blank.

The end result I want G18 to read 120 days from the date in E18, if E18
has no date, G18 should be blank.

Thank you!
Natasha

 

[Frank Kabel]

Hi
try
=IF(N(E18)=0,"",E18+120)