IF function not working =IF((B3:B6)='N'), 'FAIL')

[Mitchell_Collen via OfficeKB.com]

Hi.
I have a worksheet full of tasks that I want to keep track their test result.
I want to put a formula in the cell adjacent to every TaskTitle. This formula
will be used to scan all the tasks for that TaskTitle and check if any of
them contain an 'F' value. Most will have a 'Y' value. If there is at least
one 'F' then I want the cell adjacent to the TaskTitle to show 'FAIL'. Do you
know how to make this formula work? It will not work for me. Thanks. MC

Tasks | Results

taskTitle0 =IF((B3:B6)='N'), 'FAIL')
task1 Y
task2 Y
task3 Y
task4 Y
taskTitle4 =IF((B8:B11)='N'), 'FAIL')
task1 Y
task2 N
task3 Y
task4 Y

 

[T. Valko]

=IF((B3:B6)='N'), 'FAIL')

Try it like this:

=IF(COUNTIF(B3:B6,"N"),"FAIL","")

 

[FSt1]

hi
small syntax problem plus...
try this..
=IF(COUNTIF(B7:B10,"N")>0,"Fail","Not")

regards
FSt1