ExcelBanter - eliminating zeros

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - eliminating zeros (https://www.excelbanter.com/excel-programming/322954-eliminating-zeros.html)

Fernando Duran[_3_]

eliminating zeros

I linked two cells to get the information from other cell, but when this
cell is empty it prints "0". How can I eliminate this problem?

Ajtb

eliminating zeros

Hi
Cell C4, Cell D4 gets the value from C4.

On the worksheet itself you can usein D4 =IF(C4<0, C4,"")

In VBA, Range("D4") = Application.IF(Range("C4")<0,Range("C4"),"")

HTH
Andrew Bourke

Fernando Duran wrote:
I linked two cells to get the information from other cell, but when this
cell is empty it prints "0". How can I eliminate this problem?

Fernando Duran[_2_]

eliminating zeros

When is sheet1 to sheet2, is the problem I have.

"Ajtb" wrote in message
...
Hi
Cell C4, Cell D4 gets the value from C4.

On the worksheet itself you can usein D4 =IF(C4<0, C4,"")

In VBA, Range("D4") = Application.IF(Range("C4")<0,Range("C4"),"")

HTH
Andrew Bourke

Fernando Duran wrote:
I linked two cells to get the information from other cell, but when this
cell is empty it prints "0". How can I eliminate this problem?

All times are GMT +1. The time now is 08:29 PM.