Excel 2000 Premium

[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

 

[Andy Wiggins]

Please post the current formula you are using.

--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[J.E. McGimpsey]

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

=ROUND(<your existing formula>, 2)