M
Matthew Dyer
I'm racking my brain trying to figure this out but I can't quite hit
it.
I have a column of data. The goal is for the average of the values to
be 5. Obviously that part is easy to get. What I'd like to do is
develop a formula to determine what the value of the next piece of
data needs to be to MAKE the average 5. I've tried count(range)+1 as
the denomiator, and i'm pretty sure thats what it needs to be, but I
can't figure out what the numerator needs to be... help?
it.
I have a column of data. The goal is for the average of the values to
be 5. Obviously that part is easy to get. What I'd like to do is
develop a formula to determine what the value of the next piece of
data needs to be to MAKE the average 5. I've tried count(range)+1 as
the denomiator, and i'm pretty sure thats what it needs to be, but I
can't figure out what the numerator needs to be... help?