Excel is reading formula as a value
 

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.
--
Louise

Excel is reading formula as a value
 

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.

Louise wrote:

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.
--
Louise

--

Dave Peterson

Excel is reading formula as a value
 

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.



"Louise" wrote:

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.
--
Louise

Excel is reading formula as a value
 

Thank you Dave! My problem was I had it marked text. You made it so simple!
--
Louise


"Dave Peterson" wrote:

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.

Louise wrote:

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.
--
Louise

--

Dave Peterson
.