Inverse Sign

**Mike O** · September 4th 06, 12:24 AM posted to microsoft.public.excel.worksheet.functions

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

**CarlosAntenna** · September 4th 06, 12:42 AM posted to microsoft.public.excel.worksheet.functions

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.

--
Carlos

"Mike O" <Mike > wrote in message
...
> OK how do I get an inverse sing in an equaition in Excel? I can do it on
> my
> calculator why not here.

**[email protected]** · September 4th 06, 03:14 PM posted to microsoft.public.excel.worksheet.functions

Mike O wrote:
> OK how do I get an inverse sing in an equaition in Excel?
> I can do it on my calculator why not here.

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().

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
The fx button and the "=" sign	Carolyn	Excel Discussion (Misc queries)	3	August 23rd 06 11:04 PM
From Dollar ($) sign style to Dirhams (Dhs.) sign style	Bohemianzzrek	Excel Discussion (Misc queries)	2	April 4th 06 12:27 AM
how to change the insert function key to always be an = sign	LBURDETT	Excel Discussion (Misc queries)	7	March 24th 06 11:37 AM
How do I get an automatic equal sign to begin the formula bar?	scarlette belle	New Users to Excel	1	January 5th 06 11:07 PM
EQUAL SIGN	K Nguyen	Excel Discussion (Misc queries)	2	December 15th 05 07:30 PM