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.

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

Peco Worker wrote:

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

On 18 Mar, 20:19, Peco Worker
wrote:
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

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

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

Dave Peterson wrote:

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

Peco Worker wrote:

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

--

Dave Peterson