"Lakebum" wrote:
I have a cell that if it goes over the number 40 its
put amount over into an other cell--

Suppose the first cell is A1. If I understand you
correctly, in the "other cell", you might have the
following formula:

=IF(A1 40, A1, "")