Simon said:
Hi Joe, Thanks for the response. But unfortunately that didn't solve the
problem. I pretty had the same formula before thinking it would work.
I did not quite follow your abstract description. It is always best to give
specific details. See below for an example.
But I wonder if this does what you need:
=round(round(D11*E11,2) + round(((D11-39.45)/2+39.45)*F11,2) +
round(((D11+2)/2)*G11,2) + round(((D11/2)*H11),2), 2)
One other thing... [I wrote....]
Making assumptions about what subexpressions are rounded
"individually in other cells" [You wrote....]
This means i have each individual part of the formula i'm asking
about as another cell.
What I mean is: you were not clear about what expressions were in each
cell; you provided only one example.
And now I see you were not clear about how you did the sum of those
individual cells; in particular, whether your rounded the sum explicitly,
and if not, how you formatted the result, which affects the way in which you
perceive the result of the sum.
Here is how I would prefer you specify the details. Of course, what follows
are merely my assumptions.
A1: =round(D11*E11,2)
A2: =round(((D11-39.45)/2+39.45)*F11,2)
A3: =round(((D11+2)/2)*G11,2)
A4: =round(((D11/2)*H11),2), 2)
A5: =sum(A1:A4)
If this is what your "individual cells" and sum look like, my original
formulation of the total should work, barring any typos that I might have
made.
But now I wonder if A5 is: =ROUND(SUM(A1:A4),2). That would be the prudent
thing to do for most financial calculations.
In that case, the my amendment formulation above, rounding the sum of the
rounded subexpressions, should give you same result.
As I noted in a response to your second response to me, if this amendment
does not resolve your problem, feel free to email me the worksheet. Send it
to joeu2004 "at" hotmail.com
Caveat: If anyone suggests setting the calculation option "Precision as
displayed", I would be relunctant to do so, if I were you. Although that
might ameliorate the problem and avoid explicit rounding, there are risks
that you need to consider first.
----- original message -----
Simon said:
Hi Joe, Thanks for the response. But unfortunately that didn't solve the
problem. I pretty had the same formula before thinking it would work.
The values in the cells being referenced are dollar amounts. And when the
number is divided by 2 it seems to keep the 0.5 cent in the total
equation.
i need each individual group rounded before it totals.
It's driving me crazy!!
JoeU2004 said:
Simon said:
Sorry If I'm posting this twice, not sure if i posted in correct place
before.
It really does not matter where you post with respect to
microsoft.public.excel, m.p.e.misc, m.p.e.newusers and
m.p.e.worksheet.functions. Just post in one group, and the same
knowledgable people will probably see it.
My response to your message "I need to round in the middle of a formula"
in
m.p.e.misc....
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.
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 said:
Sorry If I'm posting this twice, not sure if i posted in correct place
before.
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
