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

Rounding Formulas
 

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

Rounding Formulas
 

=ROUND(B1*3.3%,2)

don't know why you use SUM, not that it would change the result but it
is totally obsolete when you multiply values like this.

Don't make the mistake and think what you see in the cell when formatted
for currency is what the value really is. For instance 1.249 will
display as 1.25 when formatted for 2 decimals. The underlaying value is
still 1.249 and if there are many like that there will be a discrepancy.

If you need this you need to change to precision as displayed under
toolsoptionscalculation



Regards,


Peo Sjoblom




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

Rounding Formulas
 

Sorry, you said you wanted to roundup, use this instead


=CEILING(B1*3.3%,0.01)


Peo


Peo Sjoblom wrote:
=ROUND(B1*3.3%,2)

don't know why you use SUM, not that it would change the result but it
is totally obsolete when you multiply values like this.

Don't make the mistake and think what you see in the cell when formatted
for currency is what the value really is. For instance 1.249 will
display as 1.25 when formatted for 2 decimals. The underlaying value is
still 1.249 and if there are many like that there will be a discrepancy.

If you need this you need to change to precision as displayed under
toolsoptionscalculation



Regards,


Peo Sjoblom




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

Rounding Formulas
 

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().