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

Try it like this:

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


--
Biff
Microsoft Excel MVP


"Mitchell_Collen via OfficeKB.com" <u33726@uwe wrote in message
news:90942e7980d51@uwe...
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

--
Misty :-)

Message posted via http://www.officekb.com