To ROUNDUP your formula result to two decimals.......

=ROUNDUP(SUM(B1*3.3%),2)

Vaya con Dios,
Chuck, CABGx3



"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%)