How to use a IF function containing a certain word?

GSung Registered Posts: 27 ✭✭✭✭

Hi , I would like to create a new column of data (i.e. column c) whereby if col A does not contain the word "number", then col C = Col B*10 and if not , col C = Col B

So for example, the first row in col A contains the word number , so col C = col B(i.e. 10) ; while the second row does not contain the word "number", so Col C = col B * 10 (20* 10= 200)

Col ACol BCol C (would like to generate this col)
Number of XX1010
Amount of YY20200


Setup Info
      Help me…