Addition of cells involving rounding
You need a helper cell with the formula
=ROUNDUP(D13,2)
where D13 is 999.5
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 ??
|