I need to round in the middle of a formula

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

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
 
Simon said:
=(D11*E11)+(((D11-39.45)/2+39.45)*F11)+(((D11+2)/2)*G11)+(((D11/2)*H11))
[....]
I've rounded them individually in other cells
[....]
But since they aren't rounding in the middle of the first formula,
my totals aren't matching with the second set of numbers.
Click to expand...

Making assumptions about what subexpressions are rounded "individually in
other cells":

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


----- original message -----
 
Back
Top