Golf handicap formula

[critter]

I have come up with this so far it totals hole 1-9 and subtracts the par and figures handicap@85% my problem is if some one shoots under par I get a negative answer. I would like to make any <0 to be zero but any positive number to be the actual number. Thanks Chris

=ROUND(SUM(K1-35,0)*85%,0)

[zbor]

Try =ROUND(MAX(0, k1-35)*85%, 0)

[JeanRage]

Hi,

To sum positive numbers:

Please Login or Register  to view this content.

HTH