Excel 2000 Premium

  • Thread starter Thread starter Teresa
  • Start date Start date
T

Teresa

I am working on a spreadheet where I have to multiply a
price times a quantity and my values are not calculating
correctly. My price column has a formula in it and
incorrect values are showing in my total colums. I
understand there is a formula you can add to the existing
formula that will allow the values to multiply correctly.
Can anyone tell me how to fix this problem?

Thanks.

Teresa
 
If your prices are in dollars and cents, you can use

=ROUND(<your existing formula>, 2)
 
Back
Top