Hi Everyone,
I have table with 4 column A, B, C, D:
Data sample:
I want to fill value on column D with condition column D : ((C3:C5="False")+(C3:C5="N/Y"))>0,"False","Pass") on row D1, D6, D12 (D is dynamic) (value on D row base on value on column B or column C).
Please help me or suggest keyword to search.
Thanks a lot.
I have table with 4 column A, B, C, D:
Data sample:
text A | ||
Pre-condition | ||
testB1 | OK | |
testB2 | N/Y | |
testB3 | NG | |
text B | ||
testB1 | OK | |
testB2 | OK | |
testB3 | OK | |
testB4 | OK | |
testB5 | OK | |
text C | ||
testB1 | OK | |
testB4 | N/Y | |
testB5 | OK |
I want to fill value on column D with condition column D : ((C3:C5="False")+(C3:C5="N/Y"))>0,"False","Pass") on row D1, D6, D12 (D is dynamic) (value on D row base on value on column B or column C).
Please help me or suggest keyword to search.
Thanks a lot.