What is the formula to enter in an excel worksheet to compute bowler handicap at 90%of 210?
S sjohnscott Nov 28, 2004 #1 What is the formula to enter in an excel worksheet to compute bowler handicap at 90%of 210?
D David McRitchie Nov 28, 2004 #2 Standard spreadsheet formula material. = .9 * E6 -- if your 210 total were in cell E6
B Bob Phillips Nov 28, 2004 #3 =210*90% or =A1*90% if the value is in A1 -- HTH RP (remove nothere from the email address if mailing direct) "[email protected]"
=210*90% or =A1*90% if the value is in A1 -- HTH RP (remove nothere from the email address if mailing direct) "[email protected]"
R Randy Lefferts Nov 30, 2004 #4 Assume that the bowlers average is going to be entered into A1 and assume that you want to display their handicap in B1 you would enter =(210-A1)*.9 in B1. Enter their average in A1 and their handicap will display in B1. Hope this helps.
Assume that the bowlers average is going to be entered into A1 and assume that you want to display their handicap in B1 you would enter =(210-A1)*.9 in B1. Enter their average in A1 and their handicap will display in B1. Hope this helps.
