VBA / Rounding

[srosk]

Hi there! So I am doing comparison reviews between a system calc and also using VBA to calc % based on criteria. Column T contains tenure. Our system rounds 4.9986 to 5.0, but 4.9900 would round down to 4.0.

Is there any way to properly round up / down to nearest whole # based on the above?

Ty!!

 

[Nine Zero]

Wrap your solution with the ceiling function like lets assume your variable for that 4.9900 is x then do this

WorksheetFunction.Ceiling(x,1)

 

[srosk]

Will that round 4.9986 up but not 4.9900?

 

[Nine Zero]

sorry forgot that part change it to this

WorksheetFunction.Ceiling(x,0.005)

This will round 4.9986 to 5 and leave 4.9900 alone

 

[srosk]

That's awesome!! Ty so much. New to this. Will try it out in the morning!

 

[srosk]

This worked flawlessly. Thank you again, much appreciate

sorry forgot that part change it to this

WorksheetFunction.Ceiling(x,0.005)

This will round 4.9986 to 5 and leave 4.9900 alone

 

[Nine Zero]

no problem, glad i could help