Question about Microsoft Excel for PC

Ad

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

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

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

SOURCE: how to formulate log function with excel

Here try this link

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

Posted on Nov 20, 2007

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

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

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

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.

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.

Aug 18, 2014 | Casio Office Equipment & Supplies

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

Press INV then TAN to get the arctangent.

May 05, 2013 | Texas Instruments TI-68 Calculator

Enter the value then press INV [TAN].

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

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)

While number is displayed you press the LN key. The result will be 0.000396747

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

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

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.

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

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.

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

Set your calculator to the **DEG**ree mode. Then **2nd** and **tan** buttons.

See captured image

See captured image

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

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

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

163 people viewed this question

Usually answered in minutes!

×