Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default Inverse Sign

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.



  #3   Report Post  
Old 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
Default 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().



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017