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

I need to round in the middle of a formula
 

"Simon" wrote:
=(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.

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

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