Conditional Formatting Problem
Why not simplify your formula to something like this:
=ROUND((J12*J15+K12*K15)/(J15+K15),1)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mrogozinski" wrote in message
...
It did not solve the problem. In fact, with the 2 ='s signs, it gave me a
formula error.
"Eduardo" wrote:
Hi,
Try
=round(=(SUM(J12*$J$15)+SUM(K12*$K$15))/SUM($J$15:$K$15),0)
"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?
|