if statement with text

J

jerry

I am trying to create an if statement where the string of text contains
total, if yes then perform calculation base on that row and column. if no
total in text leave blank

help
 
G

George Nicholson

=IF(ISERROR(FIND("Total", A1)),"",-yourCalculation-)

FIND returns #VALUE if "Total" is not in A1
Therefore, ISERROR returns False if "Total" is in A1 (i.e., it was found, no
error)

HTH,
 
Top