Numbers from 0-1 only

New Contributor

I have a column of numbers from 0-5 but I want to make any number above 1 to be 1

 

Any ideas

1 Reply

@Dave1959 

=MIN(A1,1)