Excel If cell contains text1 or text2

IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to see if cell contains certain substring1 like “abc” or substring2 like “def”, and returns true of false based on test result, you can build a formula based on IF function and together with SUM function and COUNTIF function. You can read more about it here : https://www.excelhow.net/if-cell-contains-either-text1-or-text2.html ######### Learn Microsoft Excel Online Free: https://excelhow.net/ #########