OK how do I get an inverse sing in an equaition in Excel? I can do it on my calculator why not here.
M Mike O Sep 4, 2006 #1 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 Sep 4, 2006 #2 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.
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 Sep 4, 2006 #3 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().
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().
