Cell = another Cell Value but shows 0

[data808]

I have a few cells that reflect values from other cells. The way I do this is by typing "=" in the formula box then whatever the other cell is that I want to copy the value from. I notice all these cells will have 0's in them if the source cell is null or blank. I also have some formatted date cells that I am doing the same thing for and they are showing as 01/00/00.

Is there any way to stop this from happening? I would just like these cells to show up as blank cells if the source cell value is blank.

Thanks!

 

[RobP]

=IF(A1<>"",A1,"")

 

[Jimmypop]

Hi There

Have you tried setting the display options for the sheet in options to Not show 0 in cells which are blank? Just uncheck the option then all cells with a zero value will show blank...

 

[data808]

=IF(A1<>"",A1,"")

Thanks. I'll try this but I already have an "=" sign in there so won't this formula interfere with that? Or maybe it covers both scenarios to copy and show "" which would be great. lol

 

[data808]

Hi There

Have you tried setting the display options for the sheet in options to Not show 0 in cells which are blank? Just uncheck the option then all cells with a zero value will show blank...

View attachment 72883

Thanks but I need this to follow the file as other people will be using this template so I don't want to have to change settings on everyone's computer. Thanks for the help though.

 

[RobP]

Thanks. I'll try this but I already have an "=" sign in there so won't this formula interfere with that? Or maybe it covers both scenarios to copy and show "" which would be great. lol

Hi, you should be able to replace your existing = sign with this kind of formula. If you preferred that it showed a "=" rather than a blank when the cell is empty, just use "=" instead of "" in the last part of my formula.

 

[data808]

=IF(A1<>"",A1,"")

Worked like a charm. Thank you so much!

 

[RobP]

you're welcome, glad to have been of service.