View Single Post
  #23   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default Excel 2003 SP2 computes the power of a negative number wrong.

Giovanni Ciriani wrote...
Google Spreadsheets=8
Open Office Calc=8

....

Because both adopted Excel's operator precedence.

This has been done before, but WTH.

Gnumeric 1.6.x 8 though it changes the formula to =(-A1)^2+A1^2
Lotus 123 R97 0 Lotus always understood math better than
Microsoft
VBA 0 using ? -2^2+2^2 in the Immediate window

In short, any software that puts compatibility with Excel worksheet
formula syntax as a high priority is likely to produce the same results
as Excel, and other software (aside from COBOL apps and some SQL
dialects) won't.