Here is the function (with a test) to calculate the range of a projectile. Since I have the same initial velocity and angle as the previous program, I should get the same result.

Use the Insert Function button under the Formulas tab to select a function from Excel’s menu list: =COUNT(B4:B13) Counts the numbers in a range (ignores blank/empty cells).