Circular Error

[Johnnie]

In worksheet 2, cell G1 I have the following formula:
=IF(F1<M1,F1,IF(F1>M1,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

 

[Bob Umlas]

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.

 

[Francis]

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