Question about Microsoft Excel for PC

1 Answer

How to write inv tan in Ms excel when I calculator use then write in calculator as follows: 119/120= inv ten then result 44.76 now my problem is how to write this calculation in excel

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Greenhorn:

    A rookie expert who has answered 20 questions on their first day.

    Night Owl:

    An expert who has answered 10 or more questions between 12 midnight and 6am on the same day.

  • Contributor
  • 52 Answers

The inverse tan, or arctan in excel is
=ATAN(A1)

Change A1 to number or cell you want the inverse tan of

Posted on Oct 19, 2012

Ad

6 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad
  • 2 Answers

SOURCE: emi using excel

The function in Excel for calculating EMI is not EMI but PMT. It requires minimum three arguments. They are 1. Rate of interest (Rate), 2. Number of periods (Nper) and 3. Value of loan or present value (Pv) in that order, that is, PMT (Rate, Nper, Pv) If you want to find EMI for 1 lakh at 10% annual interest for 10 years you enter the following in one of the cells: = pmt(10%/12, 10*12, 100000)

Borrowed from http://www.hindu.com/pp/2004/02/28/stories/2004022800160500.htm

Posted on Nov 09, 2007

jc2it
  • 58 Answers

SOURCE: how to formulate log function with excel

Here try this link

http://support.microsoft.com/kb/214116

Posted on Nov 20, 2007

  • 7 Answers

SOURCE: formula for Calculating the turn around time in excel

dpprash,

I guess you mean the number of weekdays (or working days) excluding Saturdays and Sundays. So start a spreadshhet and put the start date (01/01/2009) in A2 and the end date (31/12/2009?) in B2.

Then paste the formula below into C2:

=B2-A2-2*INT((B2-A2+WEEKDAY(A2,3))/7)-MAX(0,WEEKDAY(B2,3)-4


better-swiss

Posted on Dec 19, 2008

mbase213
  • 728 Answers

SOURCE: HOW TO CALCULATE PERCENTAGE IN MICROSOFT EXCEL?

Hi nastyguy3000;

To calculate a percentage in excel you simply take
amount/total = percentage in your cell

Example A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay ($71.20)

Have Fun

Mark

Don't forget to leave a rating.

Posted on Feb 19, 2009

label_chick
  • 407 Answers

SOURCE: need a formula to calculate length of service in excel

You could do a simple +NOW-START DATE

It would depend on the format of your start dates - i.e YY, DD/MM/YY as to the results you get.

Do want the results in years, months, days?




Posted on Jun 16, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to calculate inv logs on casio fx-82 au plus?


The inverse of log functions are power functions.
Inv of ln is exponential (e^x)
Inv of log in base 10 is 10^(x)
A function and its inverse usually share the same physical key. One function is accessed directly, the other by using the SHIFT or 2ndF key.

c98804b8-f45c-4c53-8a2f-85939a985fdd.png

Aug 18, 2014 | Casio Office Equipment & Supplies

1 Answer

Where is the shift key?


For the arctangent press INV then TAN. The INV key is two up and one left of the "7" key.

May 05, 2013 | Texas Instruments TI-68 Calculator

1 Answer

Shift tan


Press INV then TAN to get the arctangent.

May 05, 2013 | Texas Instruments TI-68 Calculator

1 Answer

BA-II Plus Calculator


Enter the value then press INV [TAN].

Jun 28, 2012 | Texas Instruments BA-II Plus Calculator

1 Answer

What is the correct order that I would enter the following In(25.21/25.20) to come up with 0.000397?


Enter 25.21/25.20 = You find 1.000396825
While number is displayed you press the LN key. The result will be 0.000396747
Be sure to set the result display mode to float [ 2nd FORMAT 9 ENTER] ]. If your calculator result display is the default one (2 decimal digits) the ratio 25.21/25.20 will have a rounded value of 1.00. ), the natural logarithm will be 0. (LN1=0)

Apr 30, 2012 | Texas Instruments BA II PLUS Financial...

1 Answer

How do i get inv on my TI-84 Plus caculator


To get the inverse trigonometric functions press the 2nd key then the trig function key. If you'll look at the key legends above the SIN, COS, and TAN keys you'll see the standard math notations for their inverse function.

Apr 05, 2012 | Texas Instruments TI-84 Plus Calculator

1 Answer

How can i calculate sin cos tan and see the result in degree mins and seconds in my calculator kadio kd82lc


When you calculate the sine cosine and tangent, the results you get are pure numbers: They have no dimensions or units because sin cos and tan are ratios of lengths.
However if you are calculating inverse trigonometric functions the results are angles, and they have units.
Use the mode key to set the angle unit to degree. after you calculate the inverse trigonometric functions, your results will be expressed in the angle unit you set in the configuration. If angle unit is degree you will get decimal degrees. To convert to DMS, use the key to the right of the change sign key (-). It is marked with degree symbol followed by what looks like a a double quote and a single quote.

Mar 18, 2012 | Office Equipment & Supplies

1 Answer

I can not find the arc key or the INV key


The INV key that you may find on some scientific calculators has, on the TI 83/84/ Plus calculators, an equivalent key marked [2nd].

On the TI83/84 Plus, each trigonometric function has a second marking [SIN^-1], [COS^-1] or [TAN^-1]. To calculate the inverses of trigonometric functions ( arc sine, arc cosine, arc tangent) you press [2nd] followed by the relevant trigonometric function key For example, [2nd] [SIN] displays sin^-1( on the command line.

Unfortunately the hyperbolic functions and their inverses are only accessed through the CATALOG. You press [2nd][0] to open the CATALOG. Then you scroll down the CATALOG list to reach cosh(, cosh^-(, sinh(, sinh^-1(, tanh(, or tanh^-1(.
To speed the search in the catalog, you use the ALPHA keyboard: To reach cosh(, press[PRGM] and you scroll down from there.

Feb 27, 2012 | Texas Instruments TI-84 Plus Calculator

1 Answer

How to perform this calculation on a TI-83 plus? 3.632/4.901=inv tan? what to press for inv?


Set your calculator to the DEGree mode. Then 2nd and tan buttons.
See captured image

3_10_2012_7_05_16_pm.jpg

Sep 22, 2010 | Texas Instruments TI-83 Plus Calculator

1 Answer

I can not find the "Inv" button...


There is an inverse button below the math button, but if you hit second and the tan it should give you the inverse of tan. Hope this is what you wanted

Oct 24, 2007 | Texas Instruments TI-83 Plus Calculator

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

163 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2888 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18408 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...