Sum of range picking up ^-10 decimal place. Is there a way to sum 2 decimal place only?

[graym463]

Hi, thanks for looking.

I am looking for a solution to sum only values up to 2 decimal place.

I have a macro that is currently summing a range and coloring yellow until it meets a certain value.

I have an error handler (at the bottom of the code), re-summing the yellow cells checking to ensure it has definitely matched the certain value. It is throwing out the error handling I have created 20% of the time due, and I have found that it is due to values that are below 0.01 value.

Thanks for your help

Please Login or Register  to view this content.

[TMS]

Maybe something like:

Please Login or Register  to view this content.

Regards, TMS

[graym463]

Thank you TMS! I have incorporated the round function and seems to working perfectly,

snippet of final code -

Please Login or Register  to view this content.

much appreciated !!

[TMS]

You're welcome. Thanks for the rep.