IF statement

Good afternoon,

i have a complex IF statement that i need help with, i have two types of product that weigh varying amounts, i need to identify different types between various weights, i have attached a spreadsheet to make it a bit clearer.

many thanks reg