Hi,
I have a book with 2 sheets. Let's say i want to reference cell A1 from sheet 1, and display its value in cell B2 on sheet 2.
(i.e. B2=Sheet1!A1)
The problem is...
In the event that cell A1 has no value entered in it, cell B2 will display the number zero.
I would like cell B2 to remain empty if A1 has no value.
Any thoughts?
Thank you
I have a book with 2 sheets. Let's say i want to reference cell A1 from sheet 1, and display its value in cell B2 on sheet 2.
(i.e. B2=Sheet1!A1)
The problem is...
In the event that cell A1 has no value entered in it, cell B2 will display the number zero.
I would like cell B2 to remain empty if A1 has no value.
Any thoughts?
Thank you