Usage average should have returned zero
Hi Folks,
I am a bit puzzled why when using Average the result did not return (0)
There is two examples:
Example A: starts and ends with a value of 1000 and returns 0.027%
Example B: starts and ends with a value of 1000 and returns 0.000%
Should Example A not have returned 0.000% too?
Perhaps the ‘Average’ formula is wrong
The maths don’t seem to add up.xlsx
Hi Folks, I am a bit puzzled why when using Average the result did not return (0) There is two examples: Example A: starts and ends with a value of 1000 and returns 0.027% Example B: starts and ends with a value of 1000 and returns 0.000% Should Example A not have returned 0.000% too? Perhaps the ‘Average’ formula is wrong The maths don’t seem to add up.xlsx Read More