Circular Reference

[AJ_Webb]

I want to enter a number in cell B12 then have excel divide that number by N2 and multiply the result by F7 and return the answer to cell B12. For example: when I enter 25 in B12, I want excel to divide 25/31 (N2-changes monthly) then multiply that number by 15 or 16 (F7-varies bi-weekly). Is this possible?



thank you
Anthony

[daffodil11]

Circular references work best with a system of checks and balances, so I'd have to ask:
How does Excel know to only execute this calculation once, instead of infinitely?


Instead of going the function route, I'd recommend you utilized little bit of VB logic. (It's never too early to start learning it!)
Let's pretend this is all going down on Sheet1. Right click the tab name at the bottom, and copy paste the code below in that location.

If B12 is changed, the procedure below runs. If n2 is blank, it aborts the run and yells at you.

Please Login or Register  to view this content.

[AJ_Webb]

That works great! Is it possible to have the same thing occur in B13, B14, B15, and B16? That would be icing on the cake for this form

[sktneer]

Try this........

Please Login or Register  to view this content.

[daffodil11]

...and Sktneer with the assist! Thanks boss!

[sktneer]

@daffodil
My pleasure....