Replacing specific numbers

J

jezzica85

Hi all,
This is probably easy, but I can't figure it out--is there a formula I could
use to replace any number in a range that's greater than 1 with 1?
Thanks!
Jezzica85
 
D

Dave Peterson

You could use a helper column of formulas:

=if(a1>1,1,a1)

Drag down, convert it to values and delete the original column????
 
D

Don Guillett

Not with a formula unless a different cell
=if(a1>1,1,a1)
You would need a macro
 
Top