powers to negative numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I find the inverse function of sine and also how do you find powers
to negative numbers
 
Dave,

Check the ASIN function for the inverse of sine under Help.

Still thinking about your other question.

Steve
 
Dave,

=ASIN(value) (arc-sine)

The return is in radians, not degrees. In degrees:

=ASIN(value)*360/PI()

For negative powers, for example,

=2^(-3)

HTH,
Bernie
MS Excel MVP
 
To get the inverse of an even power of a negative you should be able to
use something like.

=POWER(ABS(A1),1/2) where A1 is -100 the result is 10. Unfortunately,
that is not 100% accurate because 10 needs to be multiplied by -10.
This is due to the even number of times the number is multiplied by
itself.

If you are looking for odd powers then a negative is always returned.

=POWER(ABS(A1),1/3) where A1 is the negative number you are looking to
find the 3rd power of. So if A1 is -100 the result would be
-4.64158883361278 which raised to the 3rd power results in -100. Even
power analysis will always result in a positive.


Does that help?

Steve
 
Bernie:
I believe that should be =ASIN(value)*180/PI()
That's why I always use =DEGREES(ASIN(value))
best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
eliminate negative value from normal random number distribution 4
Counting consecutive negative value 7
formula to a minimum value of zero if a negative number 2
getting #N/A when vlookup is a negative number 3
How do I select a range? 2
convert negative numbers to a zero 10
Rounding Negative Numbers to Zero 4

Back
Top