Mathematical Incorrect Representations !

Great program but it can generate mathematically incorrect representations. Essentially the problem is non-compliance with BIMDAS rules.

Below are two examples where Formatted Excel Equations gives the incorrect representation:

Example 1:

Type 1/2*pi in a calculator or excel:

The correct answer is 1.570796

But Formatted Excel Equations renders this as

1 /( 2 * pi)

This equals 0.159155 which is clearly not 1.570796

Example 2:

Type 2^1^1 in a calculator or excel:

The correct answer is 2

But Formatted Excel Equations renders this as

2^11

This is clearly not 2.

I suggest the developers check the compliance of this program with BIMDAS.

Regards, Richard

Thanks for reporting these bugs.

The first example you give seems to works perfectly for us, i.e. the excel code

=1/2*pi()

gives

Alternatively:

=1*2/pi()

gives

In the second example you gave, you've correctly identified an error. This is now fixed such that

=2^37.4^3

gives

Numerically, this gives 5.964e+33

Your example:

=2^1^1

now gives

Many thanks for reporting this.

CodeCogs,

Formatted Excel Equations still seems to incorrectly formatted =2^1^1 as 2^11.

Strangely this happens with 1^1^1 and 2^2^2 but not with 3^1^1 or 3^3^3?

Richard

Hi,

This is a caching issue. The bane of our life: Make a mistake and it persists for a while until it's flushed out the system.

I've just tried a little test here and this seems to work for me. Basically our script with Excel requests an image from the the external CodeCogs servers, this in true Microsoft style relies upon Internet Explorer, so the image is actually cached by this browser even if you don't normally use it.

Solution (for us with IE7)

• Open IE
• Click on Tools Menu
• Delete Browsing History...
• Delete files...

And if that doesn't work, try Delete all.

Will.

Will,

Thanks that has fixed the problem.

Richard