Oct 23 2021 12:36 AM
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.
Oct 23 2021 02:51 AM
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.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.