## NUMBERS- variance difference- how to set a function

228 Views 2 Replies Latest reply: Nov 15, 2012 6:54 PM by queenauntie3
Calculating status...
Currently Being Moderated
Nov 15, 2012 5:31 PM

I am sooo close- I want to compare the percent difference between two columns- to compare the total in column B to total in column C-- to establisha  percent of difference be it less than or greater---help

MacBook, Mac OS X (10.7.5), time capsule
• Level 7 (28,800 points)

What's missing from your description is which column holds the base amount for the calculation. I;ll assume the original amount is in B, the changes amount is in C, and you want to know the percentage change that has occured from B.

In column D, enter =(C-B)/B

Format the result as a percent, with the number of places after the decimal that you require.

Note: The result in row 7 looks odd, but is correct to the nearest tenth of a percent.

Regards,

Barry

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.