Addition of cells involving rounding

N

Nick

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 ??
 
B

Bernard Liengme

Use =SUM(ROUND(A1:B1,1)) but commit it with CTRL+SHIFT+ENTER rather than
just ENTER
This is an array formula; Excel will enclose it in braces {}

OR use =SUMPRODUCT(ROUND(A1:B1,1)) with normal ENTER to complete
best wishes
 
D

driller

hello nick,

click tools>options>check precision as displayed
the sum value will be directly based on what u want to see.
regards
 
B

Bernard Liengme

A much better answer unless the OP want to expand to add 5 for so values
best wishes
 
Top