Just to add a bit here,

As well as using the IF function, can also use the MAX
and MIN functions to do this sort of thing. e.g.

=MAX(B1-B2,2000)

HTH
Martin

"steve45" wrote in message
...
Does anyone know how to enter a formula that tells the cell function: "if
the sum of B1-B2 is Less than 2000, then enter 2000" ???