Question about Microsoft Excel for PC

3 Answers

Formulas I need to know how I would subtract two years and than divide by the number of years and using the absolute reference for Example: Date hire: 2/28/2002 Todays' Date: 5/1/2006 I need to subtract to get the number of years and than I need to divide by the number of days in a year - 365. Can you help me I can figure out this formula

Posted by on

  • ayagil May 11, 2010

    HELLO ANYONE HELP ME ABOUT FORMULAS IN EXCEL?



    I NEED AN EXAMPLE..



    LIKE: WHAT IF I ADD,SUBTRTRACT, DEVIDE AND MULTIPLY



    A1 UP TO A6?



    HOW TO MAKE A FORMULA?



    THANKS IM VERY HOPING FOR AN ANSWER

×

3 Answers

How to addition

Posted on Jul 15, 2008

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

First you need to format the cell (format cell then customize then put yy to appear the total number of years), where 2-28-2002 minus 5-1-2006 will appear then divide it to 365 but you have to format the cell where you want the answer to appear (format cell then click number then decimal places to 2). Now you get the answer you want. Hope this will help you

Posted on Jul 14, 2008

Meri excel file ka security paasward missing. Pls i want track the paasward.

Posted on Jul 14, 2008

1 Suggested Answer

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do you find themean absolute deviation?


The mean is the arithmetic average, so add up all the numbers and divide by the number of numbers.

The standard deviation is a little more involved. The formula and example are explained here:
Standard Deviation Formulas


Good luck.

Paul

May 07, 2015 | Office Equipment & Supplies

2 Answers

What is the percent decrease


Divide 306 by 327, multiply by 100, and subtract from 100 to get about 6.4%

Sep 20, 2014 | The Learning Company Achieve! Math &...

1 Answer

Demonstrate how to multiply two binomials


Try to seek these: By using the suggested format:
Suggested su
  1. Adding and Subtracting Binomials
    • 1

      Arrange each term in each binomial in order of degree from greatest to least. The degree of a binomial is the exponent attached to the term. For example, 4x^2 is a second degree term.

    • 2

      Multiply each term in the binomial that is being subtracted by -1 to turn it into an addition problem. For example, the problem (8x^2 + 8) - (x^2 - 2) becomes (8x^2 + 8) + (-x^2 + 2).

    • 3

      Combine like terms. In the example problem, the x^2 terms are combined and the constant terms are combined, yielding (8x^2 + 8) + (-x^2 + 2) = 7x^2 + 10.

    Multiplying Binomials
    • 4

      Understand the F.O.I.L. method. F.O.I.L. is an acronym standing for first, outside, inside and last. It means that you multiply the first number of the first binomial by the first number of the second, then the numbers on the outside (the first term of the first binomial by the second term of the second binomial) and so on. This ensures that both numbers in the first binomial are multiplied by both numbers in the second.

    • 5

      Use the F.O.I.L. method to multiply the two binomials together. For example, (3x + 4)(3x - 4) = 9x^2 +12x - 12x - 16. Notice that -12x is the product of the outside terms and -16 is the product of the last terms, 4 and -4.

    • 6

      Simplify. There will almost always be like terms to combine. In the example, 12x and -12x cancel out, yielding the answer 9x^2 - 16.

    Dividing Binomials
    • 7

      Use the distributive property to divide both terms in the binomial by the monomial divisor. For example, (18x^3 + 9x^2) / 3x = (18x^3 / 3x) + (9x^2 / 3x).

    • 8

      Understand how to divide by a term. If you are dividing a higher order term by a lower order term, you subtract the exponent. For example, y^3/y = y^2. The number part of each term is handled like any other division problem. For example, 20z / 4 = 5z.

    • 9

      Divide each term in the binomial by the divisor; (18x^3 / 3x) + (9x^2 / 3x) = 6x^2 + 3x.

May 10, 2014 | Computers & Internet

1 Answer

How to find the mean absolute deviation


Add all the numbers together to get the sum.
Divide the sum by the number of numbers to get the mean.
so you have
1,2,3,4, that is 10. divide ten by four. because there are 4 numbers.
you get 2.5. Take each number and subtract 2.5. Discard all the negatives from the pile. So in essence you are taking the above example and subtracting 2.5 from 3 and 4 because the other two are going to be negative. so the answer is 3 - 2.5 and 4 - 2.5 which is 2. then take that 2 and divide by the number of items that you subtracted from which is 2. 2/2 is 1. one is the mean standard deviation.

Apr 17, 2014 | Acer Computers & Internet

1 Answer

How to find remainder as a solution in CASIO fx991ES


Finding the remainder from a division calculation is often referred to as using the MOD function, though this isn't available directly on the fx-991ES.
To obtain the remainder, for example when dividing 10 by 7, you can only divide 7 into 10 once, leaving a remainder of 3.
For larger numbers, eg when dividing 389487 by 31 (equivalent to 389487MOD31) the division gives an answer of 12564.09677 (on the display), however you only want the fractional part so subtract 12564 to give 0.0967741935 . This includes the lower value digits that were previously hidden. Then multiply this result by 31 which gives 2.999999999 on the display. Since the result of a MOD or remainder calculation involving integers has to be a whole number, the answer needs to be rounded to 3. If the answer doesn't easily round to a whole number, it is likely that you have gone beyond the calculator's working capacity.
An alternative method which avoids the rounding of the fractional part is to take the integer part of the first result (12564) and multiply it by 31 to get 389484, then subtract this from 389487, giving the answer of 3.

Dec 16, 2012 | Casio FX991ES Scientific Calculator

2 Answers

What are the formulas in grading the grades uisng microsoft excel


Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

1 Answer

What is the formula to find the percent between two numbers. example: nuts cost .233 last year and this year nuts increased to .332 what is the percentage increase.


Divide .332 by .233, multiply by 100, then subtract 100.

Alternatively, since the increase in price was .099, divide .099 by .233 then multiply by 100.

Aug 10, 2011 | Texas Instruments TI-84 Plus Calculator

1 Answer

How to calculate the percentage using the excel



Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?


Calculate the amount if you know the total and percentage For example, if you purchase a computer for $800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.

  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
1 2 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) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.
  1. Create a blank workbook or worksheet.
  2. Select the example in the Help topic. Note Do not select the row or column headers.
    Selecting an example from Help
  3. Press CTRL+C.
  4. In the worksheet, select cell A1, and press CTRL+V.
  5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.



Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

3 Answers

Ms-office


Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:
  1. =A1-A2
  2. =SUM(A1,-A2)
The above formulas refer to cell reference A2 subtracted from A1. As usual, you can use number values instead of cell references.

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Excel


Step1. Start Microsoft Excelmag-glass_10x10.gif and open the file you want to change. Step2. Double-click on the cell where you want the total to appear. Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell. Step4. Enter the formula, then press Enter. Follow the steps below for an example. Step5. Enter an opening parenthesis character: (. Step6. Enter a cell name. For example: =(E2. Step7. Press the + key. Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3). Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4. Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell. $('.Article .Steps .Image').each(function(i,e){ e = $(e); e.find('img').error(function(){ $(this).unbind(); e.remove(); }); });
Tips & Warnings
  • Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
  • Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")
I hope it helps!!!

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

Not finding what you are looking for?
Microsoft Excel for PC Logo

125 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...