View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Simon Simon is offline
external usenet poster
 
Posts: 172
Default I need to round in the middle of a formula

Hi there,

Can somebody help me to round in the middle of a formula. My formula is...

=(D11*E11)+(((D11-39.45)/2+39.45)*F11)+(((D11+2)/2)*G11)+(((D11/2)*H11))

The problem is I need the last three groups rounded individually

I've rounded them individually in other cells with
=ROUND(((M10-39.45)/2)+39.45,2)

But since they aren't rounding in the middle of the first formula, my totals
aren't matching with the second set of numbers.

I hope this is clear enough