Calculate a formula, If Then statement, based off of matching text.

[Cam4P911]

I am trying to do an if/then statement that will take text in column B and calculate the formula in column C to give me an amount then to leave it blank if there isn’t a match.

Column D’s operation would be the same with different search word.

In other words, I would like to have all of column B calculate the PreCan orders.
Column D would calculate the 1st Class orders.

​	A​	B​	C​	D​
1​	Quantity	Postage type	PreCan STD ​	1st Class​
2​	468​	PreCan STD	=A2*.0349
3​	1​	1st Class		=A3*.60

I’ve tried

=if(search("PreCan",B2)),"(=(C2*.0349)","")

=if("PreCan",B2)),"(C2*.0349)","")

 

[kevin9999]

test.xlsm
	A	B	C	D
1	Quantity	Postage type	PreCan STD	1st Class
2	462	PreCan STD	16.1238
3	1	1st Class		0.6
Sheet3

Cell Formulas
Range	Formula
C2:C3	C2	=IF(COUNTIF(B2,"PreCan*"),A2*0.0349,"")
D2:D3	D2	=IF(COUNTIF(B2,"1st*"),A2*0.6,"")

 

[Cam4P911]

Thank you so much - works great. Saved me hours of trying to figure it out and find an answer.

 

[kevin9999]

Thank you so much - works great. Saved me hours of trying to figure it out and find an answer.

Happy to help & thanks for the feedback