Excel is reading formula as a value

L

Louise

how do i get excel to read ='sf-14'!ag13 as a formula. i want the value from
one worksheet to appear on another worksheet.
 
D

Dave Peterson

Make sure that the cell that gets that formula is formated as General (or
anything but Text).

Then re-enter the formula.

You may want:
=if('sf-14'!ag13="","",'sf-14'!ag13)

Then if AG13 on sf-14 is empty, you won't see a 0.
 
T

trip_to_tokyo

EXCEL 2007

Hi Louise.

Simple example.

In Sheet 1 cell A1 I type the number 1

In Sheet2 cell A1 (this can be any sheet / cell you like) I type:-

=Sheet1!A1

This pulls in the data from Sheet 1 cell A1.

If my comments have helped please hit Yes.

Thanks.
 
Top