Remember Me?

#1
September 4th 06, 12:24 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 1
Inverse Sign

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

#2
September 4th 06, 12:42 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22
Inverse Sign

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

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.

#3
September 4th 06, 03:14 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 418
Inverse Sign

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Carolyn Excel Discussion (Misc queries) 3 August 23rd 06 11:04 PM Bohemianzzrek Excel Discussion (Misc queries) 2 April 4th 06 12:27 AM LBURDETT Excel Discussion (Misc queries) 7 March 24th 06 12:37 PM scarlette belle New Users to Excel 1 January 6th 06 12:07 AM K Nguyen Excel Discussion (Misc queries) 2 December 15th 05 08:30 PM

All times are GMT +1. The time now is 12:42 AM.