Can't divide the columns by twelve anymore

[kevs12]

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC On this forum someone taught me to divide columns by twelve -- ie everything above by twelve you just put:
=B52/12
=C52/12
=D52/12
=E52/12
=F52/12
etc.
Now when I do that I get this:
http://tinypic.com/r/15wnc3o/6

 

[John McGhie]

Click OK and it will open a debugging tool that will point to the problem
for you.

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC On
this forum someone taught me to divide columns by twelve -- ie everything
above by twelve you just put:
=B52/12
=C52/12
=D52/12
=E52/12
=F52/12
etc.
Now when I do that I get this:
http://tinypic.com/r/15wnc3o/6

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

 

[kevs12]

Thanks John.
Where do I click ok?

 

[John McGhie]

On the dialog you posted a screen-shot of

Thanks John.
Where do I click ok?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

 

[CyberTaz]

What you *haven't* told us is which cells these formulas are in. The error
message is referring to a "Circular Reference", meaning that the formula
contains a reference to the cell it's in. IOW, if you have that first
formula [=B52/12] in cell B52 it will cause that error... At least that's
the most likely cause of the error.

Further, these formulas will not divide a *column* by 12. Each will divide
the content of the specified *cell* by 12. It's irrelevant who "taught" you
this, but you've either been misinformed or have misunderstood.

It's impossible to suggest a fix because you give no idea what you're
attempting to do, what cells the data is in, where you're attempting to do
the division or anything else necessary to offer suggestions. To get a
helpful response to any question there are three keywords that describe what
need be included in your query;

1- Details,
2- Details, &
3- Details.

BTW: Did I fail to mention that you need to include Details?

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs12]

Bob, Got it! thanks. Yes was referencing wrong row.