Find value in range
If you didn't use FALSE() / TRUE() function in A-C
=IF(OR(A1="True",B1="True",C1="True"),"Check","Ok" )
"EstherJ" wrote:
I need a formula in column D that looks at the row of formulas in A-C and if
one of the formulas returns "TRUE" then I need the formula in col D to return
"CHECK"
Thanks,
Esther
A B C D
1 FALSE TRUE FALSE CHECK
2 FALSE FALSE FALSE OK
3 FALSE TRUE FALSE CHECK
4 FALSE FALSE FALSE OK
5 FALSE FALSE TRUE CHECK
|