Register
Which formula would you enter into D3, and then AutoFill into D4 to D6, to calculate the winning percentage (Pct.) for the teams?
231k views
5 votes
Which formula would you enter into D3, and then AutoFill into D4 to D6, to calculate the winning percentage (Pct.) for the teams?

User ShigaSuresh
by
7.6k points

1 Answer

3 votes
Answer:
Formula to calculate percentage are=
Winning match/total match *100
And copy paste formula of VLOOKUP in to desire cell formula bar.
Example in spreadsheet :
Winning match=A5
Total match=A6
Write formula in cell D3:
=(A5/A6)*100
And write formula of VLOOKUP into cell D4-D6 to retrieve data from desire cell.
User Morris Miao
by
8.2k points
← Prev Question Next Question →

Related questions

Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.5m questions

12.2m answers

Other Questions

How do you can you solve this problem 37 + y = 87; y =
What is .725 as a fraction
How do you estimate of 4 5/8 X 1/3
A bathtub is being filled with water. After 3 minutes 4/5 of the tub is full. Assuming the rate is constant, how much longer will it take to fill the tub?
i have a field 60m long and 110 wide going to be paved i ordered 660000000cm cubed of cement  how thick must the cement be to cover field
Link Copied!