Circular Error

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
 
B

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top