Remember Me?

#1
October 28th 04, 04:50 PM
 ~Natasha~ Posts: n/a
If cellA is blank or 0 then cellB is blank

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

--
~Natasha~
------------------------------------------------------------------------
~Natasha~'s Profile: http://www.excelforum.com/member.php...o&userid=14572

#2
October 28th 04, 04:57 PM

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

~Natasha~ Wrote:
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

--
------------------------------------------------------------------------

#3
October 28th 04, 04:59 PM
 Frank Kabel Posts: n/a

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

"~Natasha~" wrote:

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

--
~Natasha~
------------------------------------------------------------------------
~Natasha~'s Profile: http://www.excelforum.com/member.php...o&userid=14572

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post QUEST41067 Excel Discussion (Misc queries) 1 January 15th 05 10:29 PM Reggie Excel Discussion (Misc queries) 3 January 12th 05 01:04 AM tonyoc Excel Discussion (Misc queries) 1 December 10th 04 01:38 AM nayeemoddin Excel Discussion (Misc queries) 1 December 6th 04 08:07 AM TREK5200 Excel Discussion (Misc queries) 1 December 6th 04 03:23 AM

All times are GMT +1. The time now is 01:57 PM.