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
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!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 : https://docs.google.com/spreadsheets/d/1kcfglvpIj3KUIVev3mCD9fstF15zbHDJECLQbcZx-Xs/edit#gid=0