Excel

[MD]

Is there an easier way for Excel to refrence empty cells as empty cells instead of Zero.

For example if A2 is blank, then if B2 has the formula =A2 then it becomes 0, but i want B2 to equal 0 if A2 has zero.

I know that the formula =IF(A2="","",A2) will work but it seems fairly long winded to change hundreds of cells....

[goldbricker]

How about this:

=IF(ISBLANK(A2),0,2)

The method ISBLANK checks the content of the cell A2 and if it is blank then the value is 0 and if it is not then the value is 2.

[MD]

Nope you missed the point.

basically lets say cell B2 has the formula =A2 then

if A2 is blank then B2 will become 0
if A2 is 0 then B2 will become 0
if A2 is 2 then B2 will become 2
if A2 is House then B2 will become House
etc...

what I want is for B2 to contain exactly what A2 contains without having to use the formula

=IF(A2="","",A2)

(which is if A2 is blank then write a blank else write the contents of A2)

as its long winded, surely some setting or thing I can do to get the cells to contain exactly what is in fields.