=IF(='Master-H'!AW105="","",='Master-H'!AW105) to not display zeros.

What do you mean by "rounding decimals"?


Gord Dibben MS Excel MVP

On Tue, 30 Jun 2009 14:38:01 -0700, Access::Student
wrote:

Hi,
I haven't used excel in a while and have run into a problem which seems
pretty simple.

I've got a simple formula on a certain sheet of the form "='Master-H'!AW105"
, to replicate data on another form.

It work but does two things I don't like. When there are blank values in the
original sheet, it return a '0'; and decimals get rounded. I am pretty sure
it has nothing to do with formatting because exporting the data to access
those two problems still exist.

What am I doing wrong?