Could you post here the two formulae, i.e. the one where it does respond to
the other sheet changing and the one that doesn't? Don't try to retype
them in the group, just copy from the formula bar and paste here. It might
be worth having the two formulae in parallel in different cells in your
destination cell so that you can see the effects side by side while you
change the source sheet (and if need be while we do some further diagnostic
work).
--
David Biddulph

"Meenie" wrote in message
...
Hi David and Thanks for your reply :)
Yes, the formula is pointing to the right sheet. When the first formula
(the
one that's putting in the zeros that I don't want) if I enter a number
into
sheet 1 it sshows up on sheet 2. But if I change the formula to remove the
zeros, then if I enter a number on sheet 1, sheet 2 stays blank.

Yes, both sheets are open,

Yes its automatic, not manual :)
I have Excel 2003 btw... did I say that before? :)

"David Biddulph" wrote:

Firstly check that your formula on the one sheet is referring to the
correct
cell on the correct sheet in the other book.
Are the two books both open while you are doing these changes?

Secondly make sure that under Tools/ Options/ Calculation you've got it
set
to Automatic, nor Manual.
--
David Biddulph

"Meenie" wrote in message
...
I must be doing something wrong... I entered this formula and it did
make
the
cell blank instead of showing 0.00%, but when I went to the 1st sheet
and
entered a number, on the 2nd sheet it still remained blank.
<sigh

"Peo Sjoblom" wrote:

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

replace A2 with your data



--
Regards,

Peo Sjoblom



"Meenie" wrote in message
...
Hi,
I'm doing a formula that takes info from a worksheet in one workbook
and
copies it to another worksheet in another workbook.
My formula looks like this: =('[9-07 Chart Audit Compliance
CC.xls]CVT'!$C$19) and it works fine except for one thing. If the
cell
I'm
taking the info from is empty, it puts 0.00% in the worksheet I'm
copying
to.
Each cell is added and an average is taken and the 0.00% changes the
average!
What can I add to the formula to make the cell blank if the cell I'm
copying
is blank?
Boy I hope this makes sense :)

The workbook goes for a month at a time but we want to see the
averages
each
week and the 0%'s make that number incorrect until you get to the
end
of
the
month and all the cells are filled.

ALSO is there a way to make the formulas fill in correctly instead
of
having
to enter each one one at a time? (I click in the cell, type =( then
go
to
the
cell I'm copying and click it, hit enter, and the formula for THAT
cell
goes
in.
If I drag it, it doesn't change like it does in a regular workbook
where
the
info is in the same worksheet... (I know, that's two questions for
the
price
of one :D )

thanks, Meenie