What I'm trying to achieve: numbers below 5 round to a 5, numbers above 5 round to a 9.
RIGHT(ROUNDUP(SUM)) = $4.46 in the first cell I'm working on, but <=5 at the end of the first logical test comes up false. It seems to be happening with all numbers below 5, so everything is being rounded up to 9.
Interestingly an exact number of dollars will go down 1 cent to the 99 cents below. This is due to rounding error caused by the fact that decimal coinage does not have an exact representation in binary arithmetic.