if statement with text
 

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

=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,
--
George Nicholson

Remove 'Junk' from return address.


"jerry" wrote in message
...
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

George,

I was so close! Thanks !

have a great afternoon/eve

"George Nicholson" wrote:

=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,
--
George Nicholson

Remove 'Junk' from return address.


"jerry" wrote in message
...
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