If Formula

[Guest]

I am trying to figure out the if formula. I need a formula that will look at
cells d10 through ae10, and if any are 20%< than cell AF10 return a true and
if no cell is then false.

 

[Dave Peterson]

=countif(d10:ae10,"<"&0.2*af10)

I am trying to figure out the if formula. I need a formula that will look at
cells d10 through ae10, and if any are 20%< than cell AF10 return a true and
if no cell is then false.

 

[pinkfloydfan]

I am trying to figure out the if formula. I need a formula that will look at
cells d10 through ae10, and if any are 20%< than cell AF10 return a true and
if no cell is then false.

You can use the following:

=IF((D10:AE10)<AF10*20%,1,0)

BUT, you must enter it as an array, i.e. with ctrl+shift+enter

 

[Dave Peterson]

=countif(d10:ae10,"<"&0.2*af10)
displays the count.

=(countif(d10:ae10,"<"&0.2*af10))>0
with return true or false