i just need to make sure that all my previous workbook can catch up....i did
type the formulas with bunch of power shortcut....anyway try this chart
sample to show you that my reference charts made before shall require
updating....
NUMBER
on A1 : =-2
POWER
From B1 : = 2
TO B6 : = 7

=-N^X

FROM C1 : = -$A$1^$B1
TO C6 : =-$A$1^$B6

FROM D1 : = -POWER($A$1,$B1)
TO D6 : =--POWER($A$1,$B6)

SEE A CHART CURVE FOR RANGE B1:D6 :

ITS TRUE....

PLEASE HELP....

--
"Bright minds are blessed to those who share them.."-rsb.


"PapaDos" wrote:

Frankly, what you want to do is not easy, and you don't really have a need
for a solution, do you ?
If so, don't loose any time on this, it is not worth it.
Whomever is creating formulas in Excel should check their behavior before
"publishing" them (testing is part of designing).

That old peculiarity of Excel bombs out a few times a year on the web.

It's been around forever ( http://support.microsoft.com/kb/q132686/ ) and it
won't be changed anytime soon, if ever.

It is not a bug, just a different syntax interpretation than what is usually
expected.
But Excel is following precise and predictable rules in its syntax
interpretation, so I don't see this as such a big deal...

We all learned to live with it...

So no, Excel is not "computing the power of a negative number wrong", it
simply has bad reading discipline...

--
Regards,
Luc.

"Festina Lente"


"romelsb" wrote:

IN REFERENCE TO A SUGGESTION THREAD TITLED "Excel 2003 SP2 computes the power
of a negative number wrong", I kindly request your help to reestablished
confidence on engineer´s excel workbooks:
I NEED A FIND/REPLACE COMMAND FORMULA....
e.g.
=-A1^(A2+A3)
BASED FROM ABOVE :
I LIKE TO FIND ALL THE ABOVE AND REPLACE it with
=-1*A1^(A2+A3)
REGARDLESS WHETHER A1 IS A CELL REFEFRENCE OR A VALUE (2,3,4,....)...I HOPE
YOU GET MY REASON WHEN THE POWER IS AN EVEN NUMBER....
thanks and more power.....

--
"Bright minds are blessed to those who share them.."-rsb.