Formula in B1:
=MIN(A1-616.67,0)
Formula in C1
=MAX(A1-616.67,0)

copy both downwards.

HTH. Best wishes Harald

"Smilen2day" wrote in message
...
I have a spread sheet that I am working on. When I enter an amount in
column
A, I want a formula so that it will take the number I enter minus 616.67.
And if the sum is a negative amount I want the sum to enter in column b,
but
if the sum is a positive amount I want the sum to enter in column c.

How do I do this?