Dueling Excel 018

IF function with FIND, SEARCH, AND, OR, ISERROR, & ISNUMBER functions

DESCRIPTION

See Mr Excel and excelisfun use the functions: IF, FIND, SEARCH, AND, OR, ISNUMBER, ISERROR, REPLCE and VLOOKUP.

See Mr Excel and excel is fun create an IF function formula that use the functions SEARCH, FIND, AND, OR, ISERROR and ISNUMBER to determine the TRUE or FALSE for the logical test!
See the IF formula check to see if criteria is matched (or not matched) and then deposit text in the cell for a new column in a database.

WORKBOOKS




Be the first to comment

Leave a Reply