And if the "sending" cell is empty, you may want:

=if('sheet 1'!a1="","",'sheet 1'a1)

='sheet 1'!a1

will show a 0 if that sending cell is empty.

Dave wrote:

I have Excel 2000.

I have a large spreadsheet with multiple worksheets in it. I have the
need to write a formula in a cell in one of the worksheets that
references the value of a cell in a different worksheet (all in the
same spreadsheet file).

I have checked my manual & the help file, but I still could use some
assistance.

Thanks in advance for the assistance.

--

Dave Peterson