Is there a vb function that would allow me to round down to the nearest nickel or should I just write something that will change it as a string?
Printable View
Is there a vb function that would allow me to round down to the nearest nickel or should I just write something that will change it as a string?
U will need to write your own function
@ Besoup
Can you show us an example, what you would like to achieve?
VB Code:
Private Function RoundDownToNickel(ByVal dblAmount As Currency) As Currency RoundDownToNickel = dblAmount - (((dblAmount * 100) Mod 5) / 100) End Function