View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Judy Judy is offline
external usenet poster
 
Posts: 53
Default Rounding Formulas

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