Hi,

Is it possible to have a formula with all this in?

If A1=P AND B1=X then C1+2
If A1=P AND B1=Y then C1+3
If A1=P AND B1=Z then C1+5

If A1=Q AND B1=X then C1+1
If A1=Q AND B1=Y then C1+ 2
If A1=Q AND B1=Z then C1+3

If A1="" then "" (this is meant to be if A1 is empty then my cell should be empty too)

I have tried all sorts of combinations but it just gets too long and confusing and I come up with an error.