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