 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008is there a formula to show the diference between numbers?
i am crsting a spreadsheet where i will need to show the difference between one set of numbers and the average set of numbers but i am not sure how to do this. i.e average score is 6 and their score is 4 i would need it to show -2 possibly =4-6 Mike > i am crsting a spreadsheet where i will need to show the difference between > one set of numbers and the average set of numbers but i am not sure how to do > this. > i.e average score is 6 and their score is 4 i would need it to show -2 hi thanks for that, however there ae 25 average scores on 5 different matters, not all of them ae going to = -2 so i need a formula that will work in all scenarios. Regards Ollie > possibly > [quoted text clipped - 6 lines] > > this. > > i.e average score is 6 and their score is 4 i would need it to show -2 =A2-B2, where A2 is the cell in which you calculate your value of 4, and B2 is the cell where you calculate your value of 6.  SignatureDavid Biddulph > hi thanks for that, however there ae 25 average scores on 5 different > matters, not all of them ae going to = -2 so i need a formula that will [quoted text clipped - 15 lines] >> > this. >> > i.e average score is 6 and their score is 4 i would need it to show -2 The difference would be their score minus the average value. So if their score is in cell B1 and the Average is in cell A1 the formula would be: =B1-A1 SignatureKevin Backmann > i am crsting a spreadsheet where i will need to show the difference between > one set of numbers and the average set of numbers but i am not sure how to do > this. > i.e average score is 6 and their score is 4 i would need it to show -2 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.