Replacing specific numbers
 

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

Replacing specific numbers
 

You could use a helper column of formulas:

=if(a11,1,a1)

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

jezzica85 wrote:

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

--

Dave Peterson

Replacing specific numbers
 

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

--
Don Guillett
SalesAid Software

"jezzica85" wrote in message
...
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