ExcelBanter - Cell referencing SC

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell referencing SC (https://www.excelbanter.com/excel-discussion-misc-queries/133191-cell-referencing-sc.html)

[email protected]

Cell referencing SC

My question is if I have cell A1 in Sheet2 that is referenced to cell
A2 in Sheet1, I give the formula =Sheet1!A2.
If i do not have any value in A2 in sheet1 then the value shown in A1
in Sheet2 is "0", I do not want this to happen. I want it to be
cosidered as blank only and not 0. Please help me with a formula.

Toppers

Cell referencing SC

=IF(ISBLANK(Sheet1!A2),"",Sheet1!A2)

" wrote:

My question is if I have cell A1 in Sheet2 that is referenced to cell
A2 in Sheet1, I give the formula =Sheet1!A2.
If i do not have any value in A2 in sheet1 then the value shown in A1
in Sheet2 is "0", I do not want this to happen. I want it to be
cosidered as blank only and not 0. Please help me with a formula.

All times are GMT +1. The time now is 10:51 PM.