Solved IF/Then Help in Excell

August 13, 2011 at 16:13:27
Specs: Windows Vista
I'm trying to keep a cell blank if I don't put the information it needs for the formula into it.
A1 Has a date into it
B2: adds ten days to that date: =today()+10
What I'm trying to do is if I don't put a date into A1, I'd like B2 to stay blank.
Thanks for the help.

See More: IF/Then Help in Excell

Report •

August 13, 2011 at 17:29:04
=TODAY()+10 does not add 10 days to the date in A1.

It adds 10 days to the current day's date regardless of what is in any cell anywhere in the spreadsheet. =TODAY() is a standalone function that is not dependent on any other cell.

That said, you can decide whether it displays or not by using an IF function to check if A1 is populated, just as long as you are aware that regardless of what date you put in A1, you will always get the current day's date plus 10 days when you use =TODAY()+10.

=IF(A1<>"", =TODAY()+10, "")

=IF(A1<>"", TODAY()+10, "")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 13, 2011 at 17:46:39
You are right. I typed in the wrong code here, sorry.
The right one is:
= A1 +10
I'm thinking if I put this in it may work:
=IF(A1<>"",= A1 +10,"")
Will that keep the cell blank if there is no date in A1?

Report •

August 13, 2011 at 18:24:20
✔ Best Answer
Your solution is close, because my suggestion was close...wrong, but close.

You only use an equal sign as the first character in a formula, not on the inside.

Take at look at my now edited earlier response...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question