Round up formula

[mikenorris]

Column Labels

C - Cost
D - Sale Price

In C1, I have a cost of $15.65

In D1, I have a formula =C1*1.9

It returns the total as 29.735

I know that I can format the cell to only 2 decimal points, but when I reference the number to another formula, the formula still sees the 29.735

Is there a way in D1 to use the formula that I have and also tell it to round up to 2 decimal points so all other formulas only see the 2 points?

 

[Scott Huish]

=roundup(c1*1.9,2)

 

[T. Valko]

Column Labels

C - Cost
D - Sale Price

In C1, I have a cost of $15.65

In D1, I have a formula =C1*1.9

It returns the total as 29.735

I know that I can format the cell to only 2 decimal points, but when I reference the number to another formula, the formula still sees the 29.735

Is there a way in D1 to use the formula that I have and also tell it to round up to 2 decimal points so all other formulas only see the 2 points?

Maybe you just want to round to the NEAREST 2 decimal places?

=ROUND(C1*1.9,2)

The result will be 29.74.

 

[mikenorris]

thanks for the help