BL84
Member
Hi guys,
I need help with 3 formulas. They are marked by RED in the "New Pre" and "April" sheets. On the "New Pre" sheet, GIR Putt & U/D-M need a formula that will encompass whatever range is needed. I can tell you the needed info, just can't write the formula.
This would be for Round 1. GIR Putt: If there is a 1 in the GIR cell (C3), then add the putts (C2). For U/D-M: If C3 is NOT 1, and the SCORE is <= the par for the hole, count it. These would be in the proper cells in the April table shown to the right of the scores. Here are the "Pars" for each hole. 4 3 5 4 3 4 4 4 4 = Par 35. The third formula would be for the RED cells A:J and 5-9 on the "April" sheet. I have a formula there already, but that was in regards to the "Pre" sheet scores. I need a formula that will work with the Rounds listed on the "New Pre" sheet. I think the "ending" of that formula can be used, but I don't know what to put in front of it. If you have any ideas, please let me know.
Thanks
BL84
I need help with 3 formulas. They are marked by RED in the "New Pre" and "April" sheets. On the "New Pre" sheet, GIR Putt & U/D-M need a formula that will encompass whatever range is needed. I can tell you the needed info, just can't write the formula.
This would be for Round 1. GIR Putt: If there is a 1 in the GIR cell (C3), then add the putts (C2). For U/D-M: If C3 is NOT 1, and the SCORE is <= the par for the hole, count it. These would be in the proper cells in the April table shown to the right of the scores. Here are the "Pars" for each hole. 4 3 5 4 3 4 4 4 4 = Par 35. The third formula would be for the RED cells A:J and 5-9 on the "April" sheet. I have a formula there already, but that was in regards to the "Pre" sheet scores. I need a formula that will work with the Rounds listed on the "New Pre" sheet. I think the "ending" of that formula can be used, but I don't know what to put in front of it. If you have any ideas, please let me know.
Thanks
BL84