Numeric rounding always upward

I need to do a simple price calculation as number of units times unit price. The three values have the characteristics:

wkAmtDue - USD to two decimal positions, variant

wkUnits - whole number, variant

wkUnitPrice - USD to four decimal positions, variant

If the product of the multiplication is not even cents I want to increase it to the next higher cent. Normal rounding won't work since it rounds down for fractions of a cent below a half cent.

I'm guessing this is something any Idiot would know, but I'm relatively new to VB and still an Imbecile.

TIA.

Try this

Please Login or Register  to view this content.

Hope this helps