Setting multiple values of a cell based on other cells

[Lookslikerain]

I have two cells F6 is a number value, L6 is text either "Personal" or "Public"

I need to out put either "Very minor" "minor" "Serious" "Major" based on the values of F6 and L6
First part i tested is below but i cannot get any further as got stuck on addition checking of values in F6 and L6 and setting one of four outputs.

=IF(AND(E6<=100,L6="Personal"),"Very Minor","") works but is incomplete
Rules are;
If L6 <= 100 and L6=personal output is Very minor
If L6 >100 and L6=personal output is minor
If L6 <= 100 and L6=public output is serious
If L6 > 100 and L6=public output is Major

I cannot work this out using AND OR also can't get four outputs, any ideas greatly appreciated.

 

[AlanY]

how about?

=IF(F6>100,IF(L6="Personal","Minor","Major"),IF(L6="Personal","Very minor","Serious"))

 

[Lookslikerain]

That worked perfectly thank you. I was trying to include too many specific IF statements! That is a very neat solution.

 

[AlanY]

you're welcome