Perhaps in D2 something like

=IF(C2-B2<0,0,C2-B2)

translated.........
if C2-B2 smaller than zero, display zero, otherwise display C2-B2


Greetings from New Zealand
Bill K
"kevhatch" wrote in message
...
I am trying to set up a 4 day "Scorecard" for a golf tournament using Excel
2002.

Column A is players name. column B is handicap.

Column C is Day1 Gross score, D is Day1 Net score and E is a daily running
Total. Repeated for the four days with Total Gross and Net scores as the
last
two columns.

I want Column D to show the result of C -B and Column E to show the
running
total Net scores.

I was wondering if there was a formula I could use that wouldn't show and
total the Minus figure generated at Column B.

I have managed to hide it using Conditional Formatting but it is still
subtracting the handicap in B therefore not giving a true daily result.

If you can understand this! Any help would be appreciated....Thanks