how to use circular reference

Occasional Visitor

Hi I want to allow to use "circular reference" to calculate "exp^(x)=ln(x)+4x".

Before I use circular reference to calculate like x=1(x+1), its works well.

but the other one like "exp^(x)=ln(x)+4x" I use circular reference, error sign comes like "#NUM!"

or #DIV/0. pleaseeeee tell me how to fix this error. thank you all.

1 Reply


Remove or allow a circular reference

You've entered a formula, but it’s not working. Instead, you’ve got this message about a “circular reference.” Millions of people have the same problem, and it happens because your formula is trying to calculate itself, and you have a feature called iterative calculation turned off.

Click on the upper Link for more Informaions ans see the Video.


Despite my limited knowledge, I hope that I was able to help you with this information.



I know I don't know anything (Socrates)


Was the answer useful? Mark them as helpful!

This will help all forum participants.