Macro To Update < 1 to 0

[jo15765]

I need a macro that will if the Value of the cell is < 1 update that cell to 0. I tried using the below, and it didn't work

Please Login or Register  to view this content.

[MaczaQ]

hi
it's non-sens

Please Login or Register  to view this content.

cell value could not be bigger then 1 and lower then 0 in the same time

try to use only one of those conditions
i.e.

Please Login or Register  to view this content.

[jo15765]

.

Please Login or Register  to view this content.

Thank you for the quick reply! Using the above code, will set all cell sin the Range to 0 not just the ones where there value is < 1

[MaczaQ]

attach some sample workbook.
This code should not to change other cells - only those lower from 1

[jo15765]

Attached is a workbook showing what problem I am running into

[MaczaQ]

1 % is equal = 1/100 so maybe you should have following condition?

Please Login or Register  to view this content.

[jo15765]

That is removing the formula for the values that meet that condition and updating to 0, but it is also removing the value for the numbers that do not meet that condition

[MaczaQ]

I think you asked for it - try to rebuild your question, because for now I don't know what are you realy expecting

[jo15765]

If the value in cells D73:D83 is less than 1, I want to update the value of that cell to 0. I do not want the value of the cells that are greater than 1 to change at all. I want those cells to continue to display the data as they are.

[jo15765]

Does it make a difference that the cells I want to update is a formula and they display a percentage?

[OnErrorGoto0]

The last code posted should do what you want as 1% is 0.01. If it is not, then please post a workbook.

[jo15765]

Attachment 143465I thought I had a workbook posted, but your right I don't see it either. I am attaching a workbook now

[OnErrorGoto0]

The revised code works fine. The one issue you may have is that you are not displaying decimals, so in one instance your rounded values look like 1% but are actually 0.7% so the macro clears it. If you don't want that, then use:

Please Login or Register  to view this content.

[jo15765]

That got it!!! Thank you!