The expression "45 * .067" will not work because
- .067 is not a valid number - you need to prefix the zero so it is 0.067
- 45 is an integer, so 0.067 will also be coerced to an integer making the expression "45 * 0" which will give a result of zero.
If you are unsure of the variant sub-type of variables, use the C*() functions to cast the variable to the right type. See CInt(), CDbl() and so-on in the manual.
FormatNumber() will fix decimal places:
Code:
FormatNumber(45.0 * 0.067,3) ?
