Judy wrote:
I'm having a problem in rounding up the following formula to the nearest
cent. Also, I have several of these formulas in a column, when the column is
totaled it uses the full formula extension not the value shown in the cell
and it makes the total not reflect the values in the cells. How can I
correct these problems?
=SUM(B1*3.3%)

=roundup(B1*3.3%, 2)

Note: I am taking you literally when you say "round up to the nearest
cent". But as you may know, when Excel displays a number with 2
decimal places, it effectively uses ROUND(), not ROUNDUP(). If you are
trying to ensure that the column sum matches the sum of the displayed
values, I would use ROUND() in each cell, not ROUNDUP().