Thread: Circular Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Johnnie[_2_] Johnnie[_2_] is offline
external usenet poster
 
Posts: 29
Default Circular Error

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