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)