Can't Compared Rounded numbers to 0 decimal places

Hi all,

I am trying to write some VBA to compare a rounded number with a rounded number for example I have 1 number 0.5302 and another showing as 0.5308 but both show as 53% on my spread sheet therefore they equal the same and I want them to they equal the same. but when I write my code it recognises 0.5308 as higher than 0.5302. How can I adapt my code so it recognises the outputs as the same? I attach part of my code below:-

Please Login or Register  to view this content.

Any help greatly appreciated.

Cheers,

James

Hi Keebellah, I know that is what I need to do but I don't know how to write the VBA code for that part. I tried the above but couldn't get that to work. Tried with 0 instead if 2.

I don't want to compare to 2 decimal places I want to compare to 0. I have found the answer I have to use worksheetfunction.round. Thanks Keeballah.

Hi there, Norie you are correct it does need to be to 2 decimal places the fact that I saw it as a percentage confused me.