Pretty well the same suggestions you got earlier to the same post.

Have you tried ROUNDING the results?

Your formula can be written as

=ROUND((J12*$J$15+K12*$K$15)/SUM($J$15:$K$15),0)

No need for the two extra SUM's


Gord Dibben MS Excel MVP


On Tue, 23 Jun 2009 11:21:02 -0700, mrogozinski
wrote:

One of my conditional formatting rules is as follows:

If value of the cell is between 4.5 and 5.0 then format the cell "green".
The problem is the formula calculates the result as 4.497947455 (which
rounded is technically 4.5) and this cell does not format conditionally to
green.

Here is the formula:

=(SUM(J12*$J$15)+SUM(K12*$K$15))/SUM($J$15:$K$15)


Any suggestions on how to get around that?