Hello,

If criteria in cell A1 is specific text, for example "XX 0.33gal" and if in comun B, lets say cell B1 the price is 1.50, which formula to use if I want in blank cell C1 to be written "KATEGORY1".
If the price in B1 is higher or equal to 1.51 and the price goes until and equal to 1.60 I want to be written KATEGORY 2. If the price is from 1.61 to 1.70 KATEGORY 3, and above 1.7 KATEGORY 4.

How could I do this?

Thans in advance..