Question

Which formula would you enter into D3, and then AutoFill into D4-D6, to calculate the winning percentage (Pct.) for the teams?

Answer 1

I think it could be B3/($B$3+$C$3)

Step-by-step explanation:

Honestly I am not sure just guessing but I still hope this helps!

Answer 2

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.