I have a formula in a cell on Sheet2 like this:
=Sheet1!A6
This is working fine, however, until a value is entered into Sheet1, the value for the cell in Sheet2 will reflect "0". I know you can hide this by changing some display options, however, when I do that, sometimes the value I will be entering in Sheet1 will be "0" and I would like that to show on Sheet2 if a zero is entered into a cell. Basically, if Sheet1's value is blank in a cell then I want Sheet2's cell value to be blank. If a zero value is entered in Sheet1, then I would like Sheet2 to show that zero.
Is there a way to do this? Thanks.
=Sheet1!A6
This is working fine, however, until a value is entered into Sheet1, the value for the cell in Sheet2 will reflect "0". I know you can hide this by changing some display options, however, when I do that, sometimes the value I will be entering in Sheet1 will be "0" and I would like that to show on Sheet2 if a zero is entered into a cell. Basically, if Sheet1's value is blank in a cell then I want Sheet2's cell value to be blank. If a zero value is entered in Sheet1, then I would like Sheet2 to show that zero.
Is there a way to do this? Thanks.
