Hi all

I have a long list of rows (500.000 rows), based on two colums: 1) product codes 2) price

Each line of product code (contains numbers and letters) has a price.

I need to create a fomula in a third column (named 'new price') that creates a new price of all product codes that begins with the letters 'TELMO'. Those product codes that contain 'TELMO', shall have a new price: Price-100. After that, the same formula must also search for all product codes that begins with 'Basis', and create a new price to: price + 20.

Does that make sense?

Example:
Product code Price New price
Telmo10B 219 219-100
Basis60G 0 0+20

I now it's something with a If formula, probalby two if's in the same formula.

Thanks.