Hide cell contents if another cell is empty.

[Woody276]

I've been playing with this and can't figure it out. I have a cell (L10) with a simple formula in it.

What I want is for that cell to be blank if the cell 2 above it (L8) is empty.

How do I do that. I'm using MS Office 365 on the desktop.

Thanks in advance for your help.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(L8="","",your formula)

 

[Woody276]

Hi & welcome to MrExcel.
How about

=IF(L8="","",your formula)

So in cell L10 I should type

=IF(L8="","",L8-L9)

Is that right.

 

[Fluff]

Yup

 

[Woody276]

Yup

This is what I get

here's what I put in it

 

[Fluff]

In that case L8 is not blank, what's in it?

 

[Woody276]

In that case L8 is not blank, what's in it?

Your right, I went back in there and pushed delete and it is now blank. I'm not too smart sometimes.

Thanks for your help, that solved it.

 

[Fluff]

You're welcome & thanks for the feedback.