Numbers from 0-1 only

%3CLINGO-SUB%20id%3D%22lingo-sub-2257686%22%20slang%3D%22en-US%22%3ENumbers%20from%200-1%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2257686%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20of%20numbers%20from%200-5%20but%20I%20want%20to%20make%20any%20number%20above%201%20to%20be%201%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2257686%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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)