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

[intothewild]

how do you write this in vba:

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

[Jakobshavn]

Please Login or Register  to view this content.

[intothewild]

what about a worksheet function?

[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)

[intothewild]

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]

We need to loop over the cells in the range:

Please Login or Register  to view this content.

[intothewild]

brilliant thanks Jake!