Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I skip blank cells when writing formulas | Excel Worksheet Functions | |||
Printing cells with conditional formats & formulas | Excel Discussion (Misc queries) | |||
Copying Formulas In Cells That Are Not Nested | Excel Discussion (Misc queries) | |||
Copying formulas to other cells. Keeping references w/o $ sign. | Excel Discussion (Misc queries) | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) |