Sunday, July 1, 2018

yogi_Return 'NOT' If Range D2:D14 Matches Specified Text Otherwise Return 'OKAY'

Google Spreadsheet   Post  #2469

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jul-01-2018

question by: Dark Sign!topic/docs/mLPY6RsAV0s;context-place=forum/docs

if any cell in a range is anything else, return a different result?

can someone help with this, I am trying to get a specific result when a range of cells contains some specific word but also some random ones,
I want to get a different result if the range contains any other content

test file :