# 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

## 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