| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is there a formula to show the diference between numbers?
possibly
=4-6 Mike "Ollie" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is there a formula to show the diference between numbers?
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 "Mike H" wrote: possibly =4-6 Mike "Ollie" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is there a formula to show the diference between numbers?
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 -- Kevin Backmann "Ollie" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
is there a formula to show the diference between numbers?
=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. -- David Biddulph "Ollie" wrote in message ... 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 "Mike H" wrote: possibly =4-6 Mike "Ollie" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: want neg numbers to show red/pos green via if-then formula | Excel Worksheet Functions | |||
| how to seen diference colour after before 30 days | Excel Worksheet Functions | |||
| I want the total in numbers to show not the formula | Excel Discussion (Misc queries) | |||
| Accentuate diference between two values | Charts and Charting in Excel | |||
| numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
Linear Mode
