View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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 ??