Need help on an IF formula

[gooseaus]

If it has TXEQ in column A then need to add 4.00 to column C so answer reflects total with extra 4. in it…


A B C Answer current formula
C30 96,300.00 101.932 $1,860.52 =(C1-100)*B1/100
C15TXEQ 120,600.00 96.087 $(4,719.08)
F30 193,431.00 99.107 $(1,727.34)
C30TXEQ 200,000.00 96.01 $(7,980.00)
F30 124,694.00 101.641 $2,046.23
F30 172,161.00 100.274 $471.72
F30 105,915.00 102.25 $2,383.09

 

[Special-K99]

in D1
=IF(ISERROR(SEARCH("*TEQ*",C1)),C1,C1+4)

and copy down

 

[gooseaus]

thank you!!!!