Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-03-2018, 10:38 AM
joeu2004 joeu2004 is offline -2^-(-0.2) = -1.148698355 Windows 7 32bit -2^-(-0.2) = -1.148698355 Office 2007
Advanced Beginner
 
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default

I agree: the result from IMPOWER is inexplicable. -2+0i is the same as -2. So IMPOWER should give the same result as (-2)^0.2.

Arguably, (-2)^0.2 might result in a complex number (a + bi). What do you get on a TI calculator that does arithmetic with complex numbers?

You might also be surprised by the sign of the result of -2^0.2. Excel parses that as (-2)^0.2. Mathematically, 0.2 is the rational number 2/10. So arguably, (-2)^0.2 might be evaluated as ((-2)^2)^0.1, which is +1.14869835499704, not -1.14869835499704.

However, I'm sure that Excel is not clever enough to recognize 0.2 as 2/10. And technically, it is not, since the exact decimal equivalent of the binary representation is 0.200000000000000,01110223024625156540423631668090 8203125.

(I use period for the decimal point and comma to demarcate the first 15 significant digits, which is all that Excel will format, an arbitrary limitation.)

So Excel probably evaluates (-2)^0.2 like any other exponentiation by a fractional number (e.g. 0.12345). I don't know how Excel does that. And I cannot speculate because it has been too many decades since I studied that kind of math.

In any case, I suggest that you write -(2^0.2), if that is the evaluation that you intended. Unlike the language of math, unary minus has higher precedence in Excel than exponentiation.

Last edited by joeu2004; 11-03-2018 at 04:18 PM.
Reply With Quote
 



Other Forums: Access Forums

All times are GMT -7. The time now is 01:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft