Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 04:50 PM
~Natasha~
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=273272


  #2   Report Post  
Old October 28th 04, 04:57 PM
Aladin Akyurek
 
Posts: n/a
Default


=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



--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=273272

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

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
View this thread: http://www.excelforum.com/showthread...hreadid=273272




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. QUEST41067 Excel Discussion (Misc queries) 1 January 15th 05 09:29 PM
Non Blank - Blank Cells???? Reggie Excel Discussion (Misc queries) 3 January 12th 05 12:04 AM
In Exel 2000, stop the blank cells (with formulas) from printing. tonyoc Excel Discussion (Misc queries) 1 December 10th 04 12:38 AM
how to skip the blank cells nayeemoddin Excel Discussion (Misc queries) 1 December 6th 04 07:07 AM
conditional formatting blank cell TREK5200 Excel Discussion (Misc queries) 1 December 6th 04 02:23 AM


All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017