ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need to avoid a circular reference... (https://www.excelbanter.com/excel-worksheet-functions/20259-need-avoid-circular-reference.html)

Denise

Need to avoid a circular reference...
 
Want to display in D5...only...the "answer" to the formula in J5.

If I ask for the value in J5, I create a cicular reference.

Thanks!

Denise

I'm sorry - it was simple - I just needed to move my request out of the range
of the formula - moved a column and I'm okay!

Thanks!

"Denise" wrote:

Want to display in D5...only...the "answer" to the formula in J5.

If I ask for the value in J5, I create a cicular reference.

Thanks!



All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com