Can someone help me with a formula for this situation.
A=1
B=0
C=-1
example:
if i have 5a, 1b and 2c..what will be the formula for the average.
and another formula for:
D= #'s of A for the average to reach 80%
example:
*using manual computation*
5a, 1b and 2c, the average is 37.5%, so how many A do i need to reach 80%?
I'm just new with Excel, please help.
Thanks in advance!
A=1
B=0
C=-1
example:
if i have 5a, 1b and 2c..what will be the formula for the average.
and another formula for:
D= #'s of A for the average to reach 80%
example:
*using manual computation*
5a, 1b and 2c, the average is 37.5%, so how many A do i need to reach 80%?
I'm just new with Excel, please help.
Thanks in advance!