| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I correctly multiply rounded cells in Excel?
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 |
|
#2
|
|||
|
|||
|
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) "Kthought" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trace ALL dependent cells in any worksheet anywhere in Excel | Excel Worksheet Functions | |||
| Excel should allow cloaking of certain cells when copying cells b. | Excel Worksheet Functions | |||
| details about vertical alignment in Excel cells | Excel Discussion (Misc queries) | |||
| How do I center data across multiple cells in excel without mergi. | Excel Discussion (Misc queries) | |||
| How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
Hybrid Mode
