Perhaps a simple illustration
to complement your reading of Excel's HELP ..

Assuming the numbers are listed in A1 down
Put in B1: =IF(A140,A1,"")
Copy B1 down

Col B will return only numbers from col A which exceed 40,
otherwise it'll return blanks: ""
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Barb Reinhardt" wrote in message
...
Try HELP IF function.
"Lakebum" wrote in message
...
I have a cell that if it goes over the number 40 its put amount over into
an
other cell--
Thanks Lakebum