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?

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
3.5k points