Basketball three-point percentage calculator for better shooting
A basketball three-point percentage calculator turns a box-score line into a clear measure of long-range accuracy. Enter the number of three-pointers made and attempted, and the calculator divides successful shots by total tries before expressing the result as a percentage. It gives players, coaches and supporters a quicker way to interpret shooting than points alone.
Australian basketball generally uses the FIBA arc, with the three-point line 6.75 metres from the basket in club and school competitions. The same calculation applies in the NBL and WNBL, whether the action unfolds before a large crowd in Brisbane or during a Saturday social game at a local court in Parramatta.
On the sideline, Aussies might say a player is “chucking them up” or “knocking a few down”. A calculator turns that colourful language into evidence: it shows whether a run of makes represents repeatable shooting or a flattering but tiny sample. It does not replace the value of watching balance, footwork and defensive pressure.
Spreadsheet format suits the Australian market because schools, clubs and volunteers often move between shared laptops, Google Workspace and Microsoft 365. A downloadable calculator can be emailed, opened offline and reused for every round without buying a specialist statistics package. Free worksheets also let parents, teachers and casual fans follow the numbers without advanced coaching software.
What the percentage measures
Three-point percentage is the proportion of three-point attempts converted. A player who makes 7 from 20 attempts has converted 35 per cent of long-range tries. Each attempt counts once, with its value determined by the shooter’s location when the ball is released; the fact that a conversion earns three points does not change the percentage calculation.
Percentages need context because sample sizes vary. One hundred per cent from two attempts is encouraging but less dependable than 34 per cent from 50 tries. Pair the percentage with makes per game, attempts per game and the number of games played so that volume and accuracy are considered together.
If a player has no three-point attempts, leave the result as N/A rather than showing zero per cent. Zero makes from five attempts is 0 per cent; no attempts from five games is missing data. Keeping those situations separate prevents a reserve who never shot from being treated like a player who missed every long-range try.
The formula and edge cases
The core calculation is three-point percentage = (three-pointers made ÷ three-pointers attempted) × 100.
Convert the ratio to a decimal, multiply by 100 and round only for display. Four makes from 12 attempts gives 0.3333, or 33.3 per cent. Seven from 21 produces the same displayed percentage, while 8 from 20 produces 40 per cent. The equal percentages in the first two examples do not indicate equal shooting volume.
If made shots are in B2 and attempts in C2, enter =(B2/C2)*100 in D2. To handle players who did not shoot, use =IF(C2=0,"N/A",(B2/C2)*100). Format the result as a number with one decimal place, but retain the full value underneath for calculations.
Building a reusable shooting sheet
Start with one row per player and game. Useful fields include player, team, date, opponent, competition, three-pointers made, three-pointers attempted, total field goals, total attempts, free throws and notes. Separating makes from attempts is essential; a box score that gives only points cannot reveal shooting accuracy.
Keep the entry cells simple and consistent. Dropdown lists can standardise teams, opponents and competitions, while coloured backgrounds can distinguish input cells from locked formula cells. Use data validation to prevent attempts falling below makes, and protect calculated fields so an accidental keystroke does not distort the season totals.
The same resource approach works beyond the court. For example, a teacher preparing a mixed sports-and-science activity can use the photosynthesis comparison chart alongside a shooting worksheet, then ask students to identify inputs, calculations and conclusions in each task. In the basketball sheet, visible notes for N/A results make errors easier to spot.
Comparing common shooting measures
A conversion rate becomes more useful when it sits beside the other numbers coaches track.
| Measure | Calculation | Example | What it shows |
|---|---|---|---|
| Three-point percentage | 3PM ÷ 3PA × 100 | 8 of 20 = 40% | Accuracy from long range |
| Field-goal percentage | FGM ÷ FGA × 100 | 16 of 40 = 40% | Accuracy from anywhere on the floor |
| Free-throw percentage | FTM ÷ FTA × 100 | 7 of 8 = 87.5% | Consistency at the foul line |
| Points per three-point attempt | (3PM × 3) ÷ 3PA | 12 of 30 gives 1.20 | Shot value per long-range try |
Matching figures do not make the measures interchangeable. A player can shoot 40 per cent from three and 40 per cent overall; the second figure also includes two-point attempts. Points per three-point attempt adds shot value, but it still ignores shot difficulty and does not measure a player’s total offensive contribution.
Use each measure for a clear purpose. A coach can compare a player’s recent three-point conversion with their season mark, then examine attempts to avoid mistaking a quiet game for poor shooting. Benchmark against team role and playing time rather than an arbitrary internet average, since a centre may take far fewer long-range attempts than a guard.
Working through a game log
Consider a guard who starts a game with 3 makes from 8 attempts, scores 5 from 12 in the second half, and adds 1 from 5 after the break. The game line is 9 makes from 25 attempts, which is 36.0 per cent, and those makes contribute 27 points.
After each round, add the new figures to the season total. If the same player had 18 makes from 50 attempts before this game, the combined mark becomes 27 from 75, still 36.0 per cent. The extra game added volume while leaving the percentage unchanged.
Shot streaks also deserve context. Moving from 2 of 3 to 0 of 4 lowers the rolling percentage, but five attempts across two stretches is too little evidence for a firm conclusion. Keep made and missed shots by game, and add notes about open looks, contests, fatigue and the scoreboard situation. Those details help explain what the percentage cannot show.
Turning results into season trends
Create separate tabs for the game log, player summaries and league or tournament comparisons. Use formulas to calculate makes, attempts, percentage, misses and points from three-pointers for each player. A totals row can then summarise the squad without anyone retyping figures into a weekly email.
A line chart of the last five, 10 and 20 games can expose patterns that a season average hides, such as a decline after a long break or better shooting against full-court pressure. Display attempts beneath the percentage, and include games with zero attempts as N/A rather than treating them as automatic zeros. This prevents misleading trends.
For a community club in Adelaide or a school team in Perth, the routine can be simple: enter the official box score after the match, check the totals, and share the spreadsheet with coaches. A printed copy can work when venue wi-fi is unreliable, while the digital file remains ready for the next tip-off. Consistent entry is what turns the calculator into a dependable record.
Put your next shooting session into action
Start with one game rather than trying to reconstruct an entire season from memory. List every three-point attempt, record the makes and misses, calculate the percentage, and note the sample size beside the result. Once that row is complete, the same sheet can roll into weekly, monthly and full-season summaries.
MyFundRazor provides free basketball statistics worksheets and spreadsheet resources for players, teachers and club volunteers. Browse the available materials, choose a calculator or answer guide that fits your level, and adapt the layout for team totals or individual shooting lines. Keeping the source workbook organised makes every later update faster.
Choose a three-point shooting calculator, enter the first box score today, and build a record that can guide the next training session. Accurate data can show the difference between a lucky hot streak and a repeatable long-range skill.