Excel is forcing percentages to 15+ decimals long after I removed any and all references to e and LN

[Excelerate2014]

I will try anything at this point (except precision as displayed). Custom formats do not work. I have deleted every custom format and then highlight the entire workbook, every cell in every sheet and forced every number four decimals. As soon as i change a number and run manual calculation boom 15+ decimals. Excel does not seem to care (putting aside the obvious that it is simply not practical or rational to "display" 15 decimals. I have removed all references and formulas to e and LN many many versions ago. Does not matter. What can I do?

 

[joeu2004]

Wow. Cant thank you enough for the redundant parentheses tip. What a relief.

You're welcome.

Earlier you wrote:

Yes the iterative calcs [...]. Although there is no direct circular ref, the irrational #'s, are in a way circular.

I'm not sure what your misunderstanding is. Perhaps a literal translation of PI() and trig functions like COS() as so-called "circular" functions in math.

In any case, there is no relationship between Iterative calculation mode and calculations with or that result in irrational numbers. They are not "in a way circular", as the term applies to Excel.

In Excel, "circular" refers to self-referencing formulas or a system of formulas that inter-reference each other.

Iterative calculation mode and the Max Iterations count affect only how many such circular iterations Excel will tolerate. In particular, Max Iterations does not affect the number of iterations in internal algorithms such as RATE, IRR and Goal Seek.

Bottom line: Unless you have purposeful (circular) self-references in formulas, it would behoove you not to set Iterative calculation mode.

And if you have purposeful (circular) self-references in formula, it would behoove you to reconsider your design. In my experience, Iterative calculation mode does not work reliably, especially with a system of inter-referencing formulas. When Excel stops the iterations, the system of inter-referencing cells can be left in an inconsistent state.

 

[Excelerate2014]

My misunderstanding? You have no idea who I am or what I do. I'm not going to waste my time teaching you what a circle is. And please don't waste my time responding to any further of my queries with your rambling of questions and misguided assertions, which, only serve to highlight that you have no experience building the types of models that I build. Especially your last comment. Absolute nonsense.