and one last thing...
combining IFs with IFs, ANDs and ORs
You can embed 7 IFs
=if(a=a,1,if(b=b,2,etc...
You can combine AND statements - therefore having 2 tests as opposed to the normal one
=if(And(a1=1,b1=2),"if both are true","if one or both are false)
and similarly with OR
=if(or(a1=1,b1=2),"if one is true","if both are false)