In worksheet 2, cell G1 I have the following formula:
=IF(F1<M1,F1,IF(F1M1,M1,0))

I want to pull the results of this formula into worksheet 1, cell Y1 as
follows:

='Worksheet 2'!$G1

However, I keep getting a circular error. Is there a way to pull the end
result without receiving this error?

Any help would be appreciated.

Johnnie

That's not the source of your circular error. Next to the word "circular" in
the status bar will be one cell involved in the circular reference -- if
not, activate another sheet until you do see the cell reference there.

"Johnnie" wrote in message
...
In worksheet 2, cell G1 I have the following formula:
=IF(F1<M1,F1,IF(F1M1,M1,0))

I want to pull the results of this formula into worksheet 1, cell Y1 as
follows:

='Worksheet 2'!$G1

However, I keep getting a circular error. Is there a way to pull the end
result without receiving this error?

Any help would be appreciated.

Johnnie

Hi Johnnie

I tried this but didn't get the error as you mentioned.

try this
type = in cell Y1 of Worksheet 1 then
nagivate by clicking on the tab of Worksheet 2 and click on
the cell G1
press enter
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Johnnie" wrote:

In worksheet 2, cell G1 I have the following formula:
=IF(F1<M1,F1,IF(F1M1,M1,0))

I want to pull the results of this formula into worksheet 1, cell Y1 as
follows:

='Worksheet 2'!$G1

However, I keep getting a circular error. Is there a way to pull the end
result without receiving this error?

Any help would be appreciated.

Johnnie