Need help for Excel Formula

Joined
Jul 30, 2015
Messages
1
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top