Circular Error

  • Thread starter Thread starter Johnnie
  • Start date Start date
J

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
 
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.
 
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
 
Back
Top