Addition of cells involving rounding
 

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

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

Addition of cells involving rounding
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Nick" wrote in message
...
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 ??

Addition of cells involving rounding
 

=ROUND(A1,1)+ROUND(A2,1)


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

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

Addition of cells involving rounding
 

" click toolsoptionsCalculation tabcheck precision as displayed"
--
*****
birds of the same feather flock together..



"driller" wrote:

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

Addition of cells involving rounding
 

A much better answer unless the OP want to expand to add 5 for so values
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Teethless mama" wrote in message
...
=ROUND(A1,1)+ROUND(A2,1)


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