08-16-2003, 07:46 AM
Oracle,
BTW, I tested your rounding function. I think it assumes an input value with two implied decimal points. To make it more general and allow input values with explicit decimals, I removed the multiply and the divide y 100. It then works fine for me.
This clever little function of yours avoids the fact that the INT in QB will round a negative number up instead of down. Example: if I do
INT(123.9) ... I get 123. But if I do
INT(-123.9)... I get 124...... More Basic weirdness.
*****
BTW, I tested your rounding function. I think it assumes an input value with two implied decimal points. To make it more general and allow input values with explicit decimals, I removed the multiply and the divide y 100. It then works fine for me.
This clever little function of yours avoids the fact that the INT in QB will round a negative number up instead of down. Example: if I do
INT(123.9) ... I get 123. But if I do
INT(-123.9)... I get 124...... More Basic weirdness.
*****