Hi,
I am going mad over this now. I get an #DIV/0 error and I cannot figure out what is causing the error. Attached is my file. If I change the marked cell (orange) to 0,5% it returnd #DIV/0.
My iteration is set to max iter. 100 and max. change 0,001.
Does anyone have an idea?
Thanks.
Last edited by JasXel; 04-23-2019 at 09:26 AM.
Hi
Did you put check mark in the 'Enable Iterative Calculation' .
When i done its working for me...
Hey,
yes I did. It works with the figures I have attached, but when I change the marked field form 0,7% to 0,5% I get the error.
Di you change it to 0,5%?
Hi
the issue is in the Range D4:E16 the numbers here are fraction, convert them into whole numbers
Re: Circular Reference returns #DIV/0 error
OOOHHHHHHHHH!!!!! Now I see the problem!!! Thank you very much for your help!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks