Stay Blanks

[Omer]

Hi,

As U can see from the data below, rows A1&A2 are data
values I am making excell copy from another worksheet.
Although I have not enterd values for A3:A4, but the cells
are still calcuulating the fomula I entered.
How can I keep these cells empty and make excell update
A3&A4 automatically as soon as I enter data into the
original spreadsheet. Until that point leave blank.
Thanks
Omer

0.26 YES 1.77 YES 1.12 YES
1.27 NO 8.57 NO 18.55 NO
0.00 YES 0.00 YES 0.00 YES
0.00 YES 0.00 YES 0.00 YES

 

[Biff]

Hi Omer,

Here are a couple of ideas:

If you do not want *any* zero values displayed, without
using a formula, Tools>Options>View>Zero values.

or

Use a formula to test for zero values or blank cells:

=IF(Your_Formula=0,"",Your_Formula)

=IF(A3="","",Your_Formula)

=IF(ISBLANK(A3),"",Your_Formula))

Biff