Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Rounding
Hello,
I have this rounding problem, for example if I type in the cell that containing this formula =50926/.501 I get 101.648, which is fine but when I calculate in a different way such as: The sum total of a particular cell 50,926 dividing by formula start date and end date =(7/1/2004/12/31/2004)/365 I get 101,572 instead of 101,648. Why any help will be appreicate. Thank you. |
#2
|
|||
|
|||
See the answer in m.p.e.misc.
Please don't post the same message to multiple groups. It only fragments your answers, and potentially wastes the time of those answering questions that have already been answered. For tips on using these groups effectively, see http://cpearson.com/excel/topic.htm In article , "Alex Martinez" wrote: Hello, I have this rounding problem, for example if I type in the cell that containing this formula =50926/.501 I get 101.648, which is fine but when I calculate in a different way such as: The sum total of a particular cell 50,926 dividing by formula start date and end date =(7/1/2004/12/31/2004)/365 I get 101,572 instead of 101,648. Why any help will be appreicate. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
Rounding Numbers | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Rounding to the next highest 1000 after a resulting formula | Excel Worksheet Functions |