IF(...)
search function
Used Functions
Category: Logical
Specifies a logical test to perform
Syntax
IF(Something is True, then do something, otherwise do something else)
Practice IF Formula at Sheetzoom
IF formula at Microsoft helpCategory: Text
Returns a specific number of characters from a text string starting at the position you specify
Syntax
MID(text, start_num, num_chars)
Category: Text
Finds one text value within another (not case-sensitive)
Syntax
SEARCH(find_text,within_text,[start_num])
1
Finding Phone number using search function