Addition of cells involving rounding
hello nick,
click toolsoptionscheck precision as displayed
the sum value will be directly based on what u want to see.
regards
--
*****
birds of the same feather flock together..
"Nick" wrote:
If I have two cells containing formulas that are formatted to round to one
decimal place, how can I add only the rounded results of the two cells?
eg:
Displayed as:
529.9 + 469.7 = 999.5
Acctual:
529.8591944 + 469.6841614 = 999.5433558
Where I want to display:
529.9 + 469.7 = 999.6
Any thoughts or Idea's ??
|