Then let me ask you a question. Why should -A1^4-1 evaluate to a different
number than 1-A4^4 ? (-255 vs 257 for A1 equal to -4).

This striking difference goes counter the rule of commutativity additions
established several centuries ago (if not millenia): the order of the number
being added should not change the result of an addition.

"Arvi Laanemets" wrote:

Hi

Rewrite the equation as
=((-1)*(-4))*((-1)*(-4))*((-1)*(-4))*((-1)*(-4))

What do you get as result?

Maybe you wanted
=-(A1^4)


Arvi Laanemets


"Giovanni Ciriani" <Giovanni wrote in
message ...
A1 contains -4.
B1 contains the expression -A1^4
The result is supposed to be -256, but instead it is 256.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...id=e69600e5-fa
db-4745-91bb-eea8435e9c38&dg=microsoft.public.excel.worksheet.f unctions