M
mpd
Guest
How can I construct a formula (perhaps an IIF...not really sure) so that only a value which has three decimal places (and the third decimal is a half)is rounded up?
For example, I want 2.625 rounded up to 2.63 but 2.620 to remain at 2.62.
I have converted the data type to currency which does round up but the underlying value remains 2.625 which throws my totals.
For example, I want 2.625 rounded up to 2.63 but 2.620 to remain at 2.62.
I have converted the data type to currency which does round up but the underlying value remains 2.625 which throws my totals.