See below:

=(J9/4)*((J10/J9)-J11)^2 Eqn. 1

=(J9/4)*POWER((J10/J9)-J11,2) Eqn. 2

Both formulas do the same thing. ExcelCalcs provides two different presentations.

The preferred ExcelCalcs display would be from Eqn. 1. Will ExelCalcs be able to understand Eqn. 2 in the future?

Also, the square root displays the radical without the line above the radicand. In the example on the website, the line is there. And just for curiosity, will it display the index for values other than two?

Thanks for the question. In answer to the first part there are no plans to interpret the POWER() function. Generally speaking the way you input your formula will have an effect on how the equation is drawn. I am mainly worried about introducing anomalies with particular functions. For now I would keep using the '^' operator it produces a better mathematical representation.

The line above the radicand (and you have taught me a new word today) only appears if the SQRT() function is nested around OVD() and UND() functions.

e.g.
SQRT(OVD(J10)/UND(J9))

Wow tnx for answering this question sir! I was about to ask the same question about the line above the 'radicand'. Big help!

-Maxx



JohnDoyle wrote:

QUOTE:
Thanks for the question. In answer to the first part there are no plans to interpret the POWER() function. Generally speaking the way you input your formula will have an effect on how the equation is drawn. I am mainly worried about introducing anomalies with particular functions. For now I would keep using the '^' operator it produces a better mathematical representation.

The line above the radicand (and you have taught me a new word today) only appears if the SQRT() function is nested around OVD() and UND() functions.

e.g.
SQRT(OVD(J10)/UND(J9))