You are viewing an old revision of this post, from June 21, 2017 @ 00:28:43. See below for differences between this version and the current revision.

Conditional if cell has this, then display this, else display this – Google Sheets

This is a formula written for Google Sheets. It looks for text matching one of three conditions and otherwise will display 'Not Detected'. [php]=IF(ISTEXT(REGEXEXTRACT(E2,"Peter")),"Pete", IF(ISTEXT(REGEXEXTRACT(E2,"KWP")),"KWP!", IF(ISTEXT(REGEXEXTRACT(E2,"Frank")),"Frankie", "Not Detected") ) )[/php]

Revisions

  • June 21, 2017 @ 00:28:43 [Current Revision] by PeterLugg
  • June 21, 2017 @ 00:28:43 by PeterLugg

Revision Differences

There are no differences between the June 21, 2017 @ 00:28:43 revision and the current revision. (Maybe only post meta information was changed.)

Tags: , ,

No comments yet.

Leave a Reply