Yes, many of us do :-)
=IF((B1-B2)<2000,2000,(B1-B2))
This will evaluate to 2000 if (B1-B2) is less than 2000 and to (B1-B2)
otherwise...

IF syntax is
=IF(condition, value if true, value if false)
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"steve45" wrote:

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" ???