ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW TO MULTIPLY 2 CELLS THAT CONTAIN FORMULAS (https://www.excelbanter.com/excel-discussion-misc-queries/122501-how-multiply-2-cells-contain-formulas.html)

Kim

HOW TO MULTIPLY 2 CELLS THAT CONTAIN FORMULAS
 
I am trying to multiply 2 cells in another cell each of the cells already
contain formulas, the number I am getting is off by about $10. how can I get
the correct number?

[email protected]

HOW TO MULTIPLY 2 CELLS THAT CONTAIN FORMULAS
 
Nothing wrong with what you are doing. Maybe you should publish the
formulas in the two cells, and the result you are getting. Also, give
us information on the formatting. I've seen people format a cell as a
Percent, and then purposely type in the wrong values just to make it
look right.

Dom



Kim wrote:
I am trying to multiply 2 cells in another cell each of the cells already
contain formulas, the number I am getting is off by about $10. how can I get
the correct number?



bj

HOW TO MULTIPLY 2 CELLS THAT CONTAIN FORMULAS
 
It sounds as though the displayed numbers are not the same as the number in
the cells with the formulas. Without the equations and examples of what you
are seeing, it is hord to tell you exacly what is happening.

Increasing signifiant figures in the original cells or using additional
rounding to calculate only what is displayed could allow a common answer, but

Depending on your policies, I also cannot tell you which one is correct.

"Kim" wrote:

I am trying to multiply 2 cells in another cell each of the cells already
contain formulas, the number I am getting is off by about $10. how can I get
the correct number?



All times are GMT +1. The time now is 10:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com