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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum and Percentage Question... 2
how do i make a formula to multiply two values? 6
I would appreciate some help with a formula 3
Lookup/Match Formula 1
calculate shipping costs in excel 2007 2
Solution for if x = 1 and Y =2 goto C3 2
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
trying to lookup a value and return if true or fals 1

Back
Top