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

if you want to keep the decimals in the conditional formating you will have
to use decimals between 4.4909999

if this helps please click yes, thanks

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