Math (excel formulas)

posted by .

I am finding absolute and relative differences in excel. I have a compared value of 1.00 (D6) and a reference value of 38.50 (D6). I found the absolute difference to be -37.50 (D6-D9). For the relative difference I took the compared value of 1.00 (D6) and subtracted the reference value (D9) and divided it by the reference value (D9).
My formula looks like this =D6-D9/D9. I got an answer of 0.00%. When I write the formula like this =(D6-D9)/D9 it gives me an answer of -97.40%.
My teacher emailed me and said that 'The relative difference percents can be more than 100% but cannot be less than 100%.' Can someone please tell me what I'm doing wrong?

  • Math (excel formulas) -

    The order of operations says that the correct way to write this equation is

    =(D6-D9)/D9

    I'm actually doing a very similar project in Excel these days too. Good luck--it's a little tough.
    -S

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Physics/Statistics

    We're actually learning propigation of error in my chem class, but it seems to be used equally as much in Physics/Stats. My teacher showed us two methods of doing it: REAL Method (Addition/Subtraction): square root[(error absolute …
  2. math, help

    For the following set, which number has the largest absolute value?
  3. Chemistry

    How do you find Absolute error and how do you find relative error?
  4. Geometry

    Show the conhecture is false by finding a counterexample... 1. The differnece of the absolute value of two numbers is positive meaning /a/ - /b/ > 0 I do not get that.... =/ HELP. If absolute value of a is greater than the absolute …
  5. Math

    I needed to find the absolute and relative differences for these two stocks and write two complete sentences: MOD - 78.00 TRV- 3311.00 I found the absolute differences to be 3233.00 and -3233.00 and the relative differences to be 98% …
  6. Data Analysis Help

    Arithmetic operations, cell references, and __________ can be used in Excel formulas. constants macros programs procedures is it A 2Using the mouse to select a specific cell is when creating a formula is called: sizing. moving. accessing. …
  7. math

    HI, I am having trouble working this problem. This is the question: Two measurements are given. Find the absolute difference and then find the rlative difference as a percentage. Assume that the first quantity is the compared value …
  8. math

    When is the absolute value of a difference equal to the difference equal to the difference of the absolute values?
  9. math

    when is the absolute value of a difference equal to the difference of the absolute values?
  10. Math - Excel

    Hi, I need to write an Excel formula and I am trying to double check my work. We are asked to find the difference and relative difference for this account. So the values are: $10,000 $10,700 $11,400 $12,100 $12,800 $13,500 etc. The …

More Similar Questions