if cell value is greater than or equal to 2 change its value to 1

**intothewild** · 11-25-2012, 02:30 PM

how do you write this in vba:

if cell value is greater than or equal to 2 change its value to 1

**Jakobshavn** · 11-25-2012, 02:37 PM

Please Login or Register  to view this content.

**intothewild** · 11-25-2012, 02:40 PM

what about a worksheet function?

**Jakobshavn** · 11-25-2012, 02:44 PM

With a worksheet function you would be putting 1 in a separate cell.

if A1 has the value, then in B1:

=IF(A1>=2,1,A1)

**intothewild** · 11-25-2012, 02:53 PM

Originally Posted by Jakobshavn

With a worksheet function you would be putting 1 in a separate cell.

if A1 has the value, then in B1:

=IF(A1>=2,1,A1)

Thanks, seperate col is not a problem.

When i tried it in VBA it didnt work out for me...can you see what ive done wrong? ...

Please Login or Register  to view this content.

doesnt like the range i think.

**Jakobshavn** · 11-25-2012, 02:59 PM

We need to loop over the cells in the range:

Please Login or Register  to view this content.

**intothewild** · 11-25-2012, 03:03 PM

brilliant thanks Jake!

Re: if cell value is greater than or equal to 2 change its value to 1