1 / 10

Doing Math in Excel

Doing Math in Excel. Trisha Cummings. Using the Formula Tab. Math is easy to do using the – Once you have your numbers in your sheet Click on the destination cell – were you want your answer to be Click on the Formula Tab and then on the This opens a new window. Using Insert Function.

gage-foley
Télécharger la présentation

Doing Math in Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Doing Math in Excel Trisha Cummings

  2. Using the Formula Tab • Math is easy to do using the – • Once you have your numbers in your sheet • Click on the destination cell – were you want your answer to be • Click on the Formula Tab and then on the • This opens a new window

  3. Using Insert Function • Either type in what you want to do or • Scroll thru the select a function • Once you have selected your function • Click okay • This takes you to Functions arguments

  4. Function Arguments • Put in your cell addresses • Your answer will appear below as formula result • Click okay – and your answer appears in the cell

  5. Formulas • You can do the formulas on your own. • = sign in front • Average – the function you want next • ( open parenthesis • Beginning cell address • Insert separator or math symbol - : , + - / * • ) close parenthesis

  6. Functions =AVERAGE(B1:B4) =MAX(C1:C5) =MIN(D1:D4) =SUM(E1:E4) =PRODUCT(F1:F4) =QUOTIENT(G1,G2)

  7. Division • You need to put in the cell designations for the • Numerator • Demoninator

  8. Other arithmetic functions • SUM • Addition =sum(a1+a2) • Subtraction =sum(a1-a2) • Multiplication =sum(a1*a2) • Division =sum(a1/a2) • SYD = depreciation

  9. SYD(cost,salvage,life,per) • Cost is the initial cost of the asset. • Salvage  is the value at the end of the depreciation (sometimes called the salvage value of the asset). • Life   is the number of periods over which the asset is being depreciated (sometimes called the useful life of the asset). • Per   is the period and must use the same units as life.

  10. If you've bought a truck for $30,000 that has a useful life of 10 years and a salvage value of $7,500, the yearly depreciation allowance for the first year is: • SYD(30000,7500,10,1) equals $4,090.91 The yearly depreciation allowance for the tenth year is: SYD(30000,7500,10,10) equals $409.09

More Related