Inverse Sign

G

Guest

OK how do I get an inverse sing in an equaition in Excel? I can do it on my
calculator why not here.
 
C

CarlosAntenna

If your number is in cell A1, the formula is =1/A1.

Don't think about calulator buttons, think about the mathematical concepts
behing them.
 
J

joeu2004

Mike said:
OK how do I get an inverse sing in an equaition in Excel?
I can do it on my calculator why not here.
Click to expand...

Do you mean change positive to negative and negative to positive
(inverse sign)?

One way: =-A1 .

But if you are asking about data entry (CHS on some calculators), you
merely enter the minus sign as you type, e.g. -2.5 .

On the off-chance that you really mean "inverse sine" (aka arcsine),
the function is ASIN().
 

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

Excel Inverse Fft 0
What is the Function for Inverse sin 1
inverse error function 8
how do I use the inverse sine (sin -1) function in Excel 2007? 1
Inverse Tangent in excel formulae 1
log functions - inverse? 1
TAN INVERSE ? 3
Matrix Inverse 2

Top