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.

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.