Strange result

Hi again.

I'm not trying to be a pain about it, but as I was demonstrating the tool to a colegue I was dissapointed to see the result of rendering this particular (ugly but valid) Excel formula:

=1-(1-S37)*(1-R38)/F6-(1-S37)*R38*F6

It does not look at all the way it should. Changing it a bit to:

=1-((1-S37)*(1-R38))/F6-(1-S37)*R38*F6

helps, but how come that the last part gets included with the denomenator? (in the original formula).

You are not being a pain at all. In fact your feedback is fantastic.

This is a rather silly error, that I'm sure we can resolve today. Doesn't actually need to be anything more complicated than:

=(A1)*(R38)/F6-A3

The error is simply that we're not resetting a few flag once we've analysed the first equation fraction, so subsequent parts of the equation over flow into this.

Problem is fixed. We've also enhanced the treatment of brackets so they system will remove when possible redundant brackets, i.e.

=((A1+A2))*(((A3)))

becomes just We could in theory take this further, but sometime the user may actually extra brackets for their own clarity.