conditional formatting gliche.


M

mrogozinski

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.

Any suggestions on how to get around that?
 
Ad

Advertisements

M

Mike H

Hi,

It would have helped to see your CF formula but maybe this

=AND(ROUND(A1,2)>=4.5,ROUND(A1,2)<=5)

Mike
 
Ad

Advertisements

D

David Biddulph

Perhaps you could explain to us in what way you expect
=(SUM(J12*$J$15)+SUM(K12*$K$15))/SUM($J$15:$K$15)
to differ from
=(J12*$J$15+K12*$K$15)/SUM($J$15:$K$15) ?

Or perhaps you intended to say
=SUM(J12*$J$15,K12*$K$15)/SUM($J$15:$K$15) ?
or
=SUMPRODUCT(J12:K12,$J$15:$K$15)/SUM($J$15:$K$15) ?

Just remember that if you give the SUM function only one argument, it has
nothing to SUM it with.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top