Sunday

December 21, 2014

December 21, 2014

Posted by **Emily** on Sunday, March 1, 2009 at 12:41am.

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) -
**Sadler**, Sunday, March 1, 2009 at 4:59pmThe 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

**Answer this Question**

**Related Questions**

Excel - How am i to Calculate the appropriate discount using the IF function ...

Excel & Math - I'm not sure what two excel functions to use that will give the ...

Math/Excel - I'm not sure what two excel functions to use that will give the ...

MS Office Suite - I am familiar with Excel 2007. I just got the news that I will...

Data Analysis Help - Arithmetic operations, cell references, and __________ can ...

math - HI, I am having trouble working this problem. This is the question: Two ...

Chemistry - How do you find Absolute error and how do you find relative error? ...

Statistics - Excel - Can anyone help me with finding Standard Deviation in Excel...

math, help - For the following set, which number has the largest absolute value...

Math - 1. Suppose a and b are integers, and the absolute value of a is > than...