Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2006

Tip: Looking for answers? Try searching our database.

Exponential Function Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bernie Hunt - 15 Mar 2006 06:57 GMT
I've run into a problem I don't understand using power functions. I've only
done limited work with powers in Excel, but I've run into a problem with
this formula;

=(-0.01^ (2/3))

This returns #Num

I tried to reformat to
=POWER(-0.01, (2/3))

and still get the same #Num.

I split the exponent into
=((-0.01^ (2))^(1/3))
and this works.

Why don't the first two formats work?

Thanks,
Bernie
Ron Rosenfeld - 15 Mar 2006 08:28 GMT
>I've run into a problem I don't understand using power functions. I've only
>done limited work with powers in Excel, but I've run into a problem with
[quoted text clipped - 17 lines]
>Thanks,
>Bernie

Look at HELP for operator precedence.

Unless instructed by the use of parentheses, Excel will evaluate the negation
operator prior to the exponentiation operator.

In your first two examples, you are trying to computing the exponent of a
negative number.  My limited math background leads me to believe that the
example you give would result in an irrational number.  But I'm sure others
more knowledgeable will chime in

In your last example, you are squaring the negative number first (which gives a
positive number) and then taking the root of that positive number.

--ron
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.