You dont say what you want to do if A1 = 5. Im assuming if it = 5 then return 5
=IF(A1=5,5,A1)

"Carolan" wrote:

Need a formula - I know it's simply - just can't get it.
If A1 is greater than 5, then B1 = 5
If A1 is less than 5, B1 should equal the amount in A1
CarolAnn