Something to be aware of if you are wanting to
keep the whole number and disregard the .xx
Code:Dim x as double x = 62.65 'if .xx more than .5x msgbox round(x) + 1 'returns 64 msgbox cint(x) + 1 'returns 64 msgbox fix(x) + 1 'returns 63 fix always reverts to the whold while cint,round, will go higher if fraction over 5




Reply With Quote