How do I correctly multiply rounded cells in Excel?

G

Guest

When I mulitply a cell that has a formula calculating a number that is then
had the ROUND function applied to it, the value using the cell is not
correct. EG. $15.37 x 650 = $9992.32. 650 is a rounding figure and the
answer should be $9990.50
 
B

Bob Phillips

Looks like the cell wasn't rounded, just formatted to 2 dec places.

Try

=ROUND(A1,2)*B1

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Excel Stop Excel from displaying rounded values 4
Calculating Sum - when numbers are rounded... 2
Reverse string on multiply cells 3
Countif, then multiply?? 4
How do I multiply (1 cell) times a rge of cells to a rge of cells 3
subtraction returning incorrect calue 5
Mutiply in a range of cells ? 1
Paste Special Multiply Formulas not working in Excel 2007 1

Top