View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ashkan Ashkan is offline
external usenet poster
 
Posts: 31
Default 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