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

=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

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

regards
FSt1

"Mitchell_Collen via OfficeKB.com" wrote:

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