Skip
# Excel formula that hides results

Post

# Excel formula that hides results

March 6, 2014 4:47 AM Subscribe

I am drowning in Google results! Looking for help making a formula that will only show a value once data is entered into another cell.

I have one cell which can have a date added to it, and an adjacent cell which needs to show the following month.

I have tried this but it isn't working:

=IF(A1="","",(A1+30))

help!

I have one cell which can have a date added to it, and an adjacent cell which needs to show the following month.

I have tried this but it isn't working:

=IF(A1="","",(A1+30))

help!

Define: "isn't working". What do you get?

"A1+30" isn't adding a month. You need to fiddle with the dates a bit, but without knowing what you want and what you're getting, there's no answer to this.

posted by pompomtom at 4:53 AM on March 6

"A1+30" isn't adding a month. You need to fiddle with the dates a bit, but without knowing what you want and what you're getting, there's no answer to this.

posted by pompomtom at 4:53 AM on March 6

By the way, to add a month, you can use the

posted by grouse at 4:55 AM on March 6 [2 favorites]

`EDATE`

function, as in `=IF(A1="","",EDATE(A1,1))`

.posted by grouse at 4:55 AM on March 6 [2 favorites]

Typo on the cell reference of my original formula!! This is what happens when you stare at a spreadsheet all morning. The EDATE is new to me so thanks grouse.

posted by ellieBOA at 4:59 AM on March 6

posted by ellieBOA at 4:59 AM on March 6

OMG- EDATE function, where have you been all my life!

Once again, Meta Filler prepares me for the work day

posted by Lesser Shrew at 5:38 AM on March 6

Once again, Meta Filler prepares me for the work day

posted by Lesser Shrew at 5:38 AM on March 6

For reference, though,

posted by Wolfdog at 1:58 PM on March 6 [2 favorites]

`=ISBLANK(A1)`

is the way to test whether a cell is really blank. Under certain circumstances, `A1=""`

and `ISBLANK(A1)`

can return different results.posted by Wolfdog at 1:58 PM on March 6 [2 favorites]

Type just a single quote

posted by Wolfdog at 3:31 PM on March 6 [1 favorite]

`'`

in A1. This makes it an empty string and =(A1="") will return TRUE while =ISBLANK(A1) will return FALSE.posted by Wolfdog at 3:31 PM on March 6 [1 favorite]

ellieBOA's formula cell will also return different results for =(A1="") and =ISBLANK(A1). If her formula evaluates to True, the cell will equal "" but won't be considered blank (because it has a formula in it).

posted by lostburner at 4:01 PM on April 4

posted by lostburner at 4:01 PM on April 4

You are not logged in, either login or create an account to post comments

A1:

`1/1/2014`

B1:

`=IF(A1="","",(A1+30))`

and set B1 to have a date format, B1 will display 1/31/2014 (which is not a month later, but that's another problem altogether). If I delete A1, B1 disappears.

What happens for you?

posted by grouse at 4:52 AM on March 6