how to round down

[glda19]

Hi
How can i do a mround down in vb. with multiple 0.5

So tat 0.75 will be 0.5

[MrShorty]

Easiest is probably to use Excel's FLOOR() function: https://support.office.com/en-us/art...7-b0b4de5a8886
You can call Excel's functions from VBA using the Application object or the WorksheetFunction object: https://docs.microsoft.com/en-us/off...n-visual-basic

[shg]

Or ...

Please Login or Register  to view this content.