Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Changing format for -2^2?
0 views
Skip to first unread message
Tim Walters
Nov 22, 2009, 7:35:17 PM11/22/09
to
Shouldn't minus a squared number be a minus number? In Excel -2^2 = 4. To
keep it negative I have to write -(2^2). Is there a way to customize this so
that -2^2 = -4?
keep it negative I have to write -(2^2). Is there a way to customize this so
that -2^2 = -4?
Thanks.
Dave Peterson
Nov 22, 2009, 8:06:59 PM11/22/09
to
Excel documents its behavior in its help. (Yep, it's not the familiar order of
precedence.)
precedence.)
You found the solution.
--
Dave Peterson
Bernard Liengme
Nov 23, 2009, 8:39:22 AM11/23/09
to
As Dave points out, in Excel negation takes precedence over exponentiation
I not sure this is 'unusual' but the Math3 onscreen calculator does
evaluate -2� as -4 as does Maple, so he may the correct - I have gotten used
to Excel's ways
But I do know you cannot alter it
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP
I not sure this is 'unusual' but the Math3 onscreen calculator does
evaluate -2� as -4 as does Maple, so he may the correct - I have gotten used
to Excel's ways
But I do know you cannot alter it
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP
"Tim Walters" <timwa...@DROPTHISterra.es> wrote in message
news:3a9ath....@news.alt.net...
0 new messages