Archive of Mr Excel Message Board

Back to Errors in Excel archive index
Back to archive home

Circular Reference

Posted by Christine on August 07, 2001 5:05 AM

Ok, is there a formula that can be used to calculate a figure inside a cell, referring to that cell? I need to enter an amount in the cell, say 7.5 and have it automatically be multiplied by 10.725 and put that calculation in THAT cell.

Thanks!

Re: Circular Reference

Posted by Aladin Akyurek on August 07, 2001 5:56 AM

Christine,

You can't enter a number into a cell that contains a formula (one with or without a circular reference). Hope I'm not misreading you.

Aladin

Re: Circular Reference

Posted by Rob Jackson on August 07, 2001 6:00 AM

I dont think so, any formula in a cell would be overwritten by you entering the 7.5

Rob

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.