Previous Topic Next Topic

Leaving a Cell Blank if one value of the formula is blank

Closed
peckman Posts 1 Registration date Saturday November 10, 2012 Status Member Last seen November 10, 2012 - Nov 10, 2012 at 12:27 AM
MelyElly Posts 3 Registration date Wednesday November 21, 2012 Status Member Last seen November 23, 2012 - Nov 21, 2012 at 08:07 PM
Hello,

I was making a template to be distributed to multiple receivers. Since the template is blank and must automatically count the number of days an employee has been around since the date of employment, i could not find the right formula where the cell with the difference between two dates will appear blank if one of the cell is blank.

Please see the example below:
- A1 = to the hire date of the employee
- A2 = automatically computes for the days of tenure with this formula: (TODAY())-A1

The problem is if cell A1 is blank, A2 will show 41223. This is a file template that needs to be sent and A1 should be left blank for the receiver to fill with the appropriate information.

I hope someone could give me the right formula to this.

2 responses

Answer 1 / 2
aquarelle Posts 7180 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 491
Nov 10, 2012 at 12:05 PM
Hi,

Try this formula :
= IF(A1="",""),TODAY()-A1)

Regards
Answer 2 / 2
MelyElly Posts 3 Registration date Wednesday November 21, 2012 Status Member Last seen November 23, 2012
Nov 21, 2012 at 08:07 PM
This is the exact function you need:
=IF(A1="","",(TODAY())-A1)
It should work perfectly!

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

Hello, Why the end to end encryption message will appear several times in a chat at different dates with no other conversation? Does that mean the chat has been deleted and activated again, then deleted again at another date and reactivated again?

1 response
blank white page for website
yadaves -
ac3mark -

there is white blank page after loading [REMOVED BY MODERATOR]

help me to get it solve so that i am able to get my result ...

1 response
using web browser page loads but screen blank
inchoate -
leo -

Hello,
On my laptop, none of my web browsers are able to actually display any page on the internet. I will say the page is loaded, but the web browser window will be totally blank. One that particular computer, I tried firefox, googlechrome, and internet explorer. For explorer it showed a message saying it couldn't find any of the pages I tried to open, I think it said that there was an HTML error. What should I do?

Laptop Configuration:
Dell insperon notebook w/
Windows XP

Web browsers:
Google Chrome
Modzilla Firefox
Internet explorer

16 responses
using nested if to blank out adjacent cells
WILLYB -
mubashir aziz -

Hello,
I would like to use a formula to blank out adjacent cells if a specific value is entered
for example:

I have cells A1, B1, C1

If I put the value of "X" in any one of the cells I would like the other two cells to be blanked out.


can anyone help me with this?

3 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

I hope someone can help me with this...I've done this before but can't remember how.

I have a list of names (for an attendees list) and I need to show an extended total for each
person and the number of guests they will bring. Here's the layout...

B2 is the person's name
C2 is the number of guests they will bring
D2 is the total for that person (including them)

I need a formula that says: If B2 has any text, then add a value of "1" to C2 and enter the total in D2.

Hope that makes sense. Thank you in advance for helping.

20 responses