The OP *may* have wanted something completely different (neither 0 nor
A1-600), but I was relatively confident in guessing in this case. :-)
--
David Biddulph
"Rick Rothstein (MVP -
VB)" wrote in
message ...
=IF(A1<600,0,A1-600)
or
=MAX(A1-600,0)
Strictly, you haven't specified what you want if A1 is *equal* to 600,
but I've guessed.
Since A1-600 equals 0 when A1 equals 0, would it have been possible for
you to have guessed wrong?<g
Rick