There arent any values plugged into this spreadsheet yet, but I am stuck on how to create an if function..

In G12, calculate Goal Percentage by dividing the number of Goals by the number of Shots. This will display an error message because there are zeros in column F. We dont want to display error messages in the file, so an IF statement that tests the value of column F will solve this problem.

Change the formula in G12 with the following three pieces:

Test is F12 greater than zero

If the Test is True divide the number of Goals by the number of Shot

If the Test is False enter a zero