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.4m questions

12.2m answers

Other Questions

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
Write words to match the expression. 24- ( 6+3)
A dealer sells a certain type of chair and a table for $40. He also sells the same sort of table and a desk for $83 or a chair and a desk for $77. Find the price of a chair, table, and of a desk.
Link Copied!