software

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

You could use a helper column of formulas:

=if(a1gt;1,1,a1)

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

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

--

Dave Peterson

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

--
Don Guillett
SalesAid Software

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