Rounding

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

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.
 
Unless you have Tools/Options/Calculation/Precision as displayed set,
calculations in XL are done with the values stored in the cells, not
necessarily the values displayed.

For instance

=("12/31/2004"-"7/1/2004")/365

is stored as 0.501369863013699 (expand the number of decimal places to
check), so your results will vary from the case when you use 0.501.
 
Back
Top