If greater than 5

[Carolan]

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

 

[Mike]

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

 

[T. Valko]

If A1 is greater than 5...

If A1 is less than 5...

What if A1 **IS** 5?

See if this does what you want.

=MIN(A1,5)

 

[Carolan]

Sorry, I'm trying to say if what is in Column A is 5 or greater, then in
Column B the result should be 5. If what is in column A is less than 5,
Column B should equal the exact same amount

A B
1 5.5 5
2 4.2 4.2

 

[T. Valko]

Ok, the formula I suggested will do what you want.