help with circular formula problem..

S

sarked

New Member
Joined
Jun 15, 2002
Messages
20
hello..

in cell A20 of current workbook, i have the formula:

=$D14*[file2.xls]Sheet1!Z$10

in cell A1 of current workbook, i have the formula:

=Sheet2!B2


what i did was to edit the A20 cell into:

=IF( A1 <= 0.80, ($D14*[file2.xls]Sheet1!Z$10), 0)

then excel tells me its a circular formula error but it can't show me where...

help pls..

thanks in advance..
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
This could go on for a while, depending on the complexity of your spreadsheet. When Excel gives you the circular reference message, doesn't it come up with a blue arrow pointing to where the problem is? What version of Excel are you using.
Richard
 
Upvote 0
what about D14 or Z10, is there a ref to A1?

_________________
Win 98SE - Office 2K
This message was edited by dsnbld on 2002-06-26 18:15
 
Upvote 0
well.. looking into the formulas, there really was a circular referenece. it just go way deep and into different sheets...

it's just that excel said it could not show me the circular reference.. it did not show those blue lines that we could follow.. i got confused there..

thanks for the help...
 
Upvote 0
You must log in or register to reply here.

Similar threads

JeffGrant
  • Question
Circular References Error Message Started Popping Up
Replies
8
Views
333
Alex Blakenburg
A
I
  • Solved
Workaround Formula to prevent Circular Reference Error
2
Replies
12
Views
451
Peter_SSs
Peter_SSs
D
  • Question
macro to compare two excel file.
Replies
4
Views
2K
DanteAmor
DanteAmor
K
  • Question
Trying to dissect circular references...
Replies
1
Views
579
kyddrivers
K
S
  • Solved
Lookup formula
Replies
4
Views
187
Joe4
Joe4

Forum statistics

Threads
1,215,161
Messages
6,123,380
Members
449,097
Latest member
Jabe

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top