J
Jeff
I am a novice at Excel 2007. Pete_UK has been very kind in helping me
use the =AVERAGE formula.
I have a new but related question:
In the cell that contains the calculated average, is there an XL tool or
something that would show the underlying numbers in the calculated average?
I do not mean the formula or the cell addresses used. I mean the actual
numbers.
Example:
If A2, R2, AA2 contain 2, 4, 6, the calculated average will be 4. Can I
click on the cell containing the calculated "4" and see that XL obtained
this from "2,4,6"?
Jeff
use the =AVERAGE formula.
I have a new but related question:
In the cell that contains the calculated average, is there an XL tool or
something that would show the underlying numbers in the calculated average?
I do not mean the formula or the cell addresses used. I mean the actual
numbers.
Example:
If A2, R2, AA2 contain 2, 4, 6, the calculated average will be 4. Can I
click on the cell containing the calculated "4" and see that XL obtained
this from "2,4,6"?
Jeff