IF statement help

[Giggzz]

=IF(L5:L11="TRAINING",12,SUM(J15/L15)) is giving me #value error when the statement is true. Any idea why? Thanks

 

[Zack Barresse]

Yes, it will fail, because you are trying to pass a linear array into a single value syntax. Why not try using something like this ..


=IF(COUNTIF(L5:L11,"Training")=7,12,J15/L15)


HTH

 

[Giggzz]

Thanks that did it.... looking at the code what is the =7? always wanting to learn ....

 

[babycody]

The amount of rows from L5 to L11

 

[Yogi Anand]

So, nstead of 7, you could use ... =ROWS(L5:L11);

and if L5:L11 had been assigned a range name yRange ... you could use =ROWS(yRamge)

 

[Giggzz]

How would you write it if you were to skip a cell or two in the range?

 

[Scott Huish]

Did you want it to be true if any cell in L5:L11 is TRAINING ?

If so, perhaps:

=IF(COUNTIF(L5:L11,"Training"),12,J15/L15)