I have the following IF Statements. Can some one please help me add them all
together or enlighten me to a simpler way.

I basically want to say...
If A=High and B=+Major put YY,
if B=+moderate put YY,
if B=+minor put Y,
if B=negligible put O,
if B=-minor put N,
if B=-moderate put NN and
if B=-major put NN.....
BUT IF A=Medium and B=+major put YY,
if B=+moderate put Y,
if B=+minor put O,
if B=negligible put O,
if B=-minor put O,
if B=-moderate put N and
if B=-major put NN.....
BUT IF A=Low and B=+major put Y,
if B=+moderate put O,
if B=+minor put O,
if B=negligible put O,
if B=-minor put O,
if B=-moderate put O and
if B=-major put N

=IF($B$3="High",IF(B$9="+Major","YY",IF(B$9="+Mode rate","YY",IF(B$9="+Minor","Y",IF(B$9="Negligible" ,"0",IF(B$9="-
Minor","N",IF(B$9="- Moderate","NN",IF(B$9="- Major","NN","0"))))))))

=IF($B$3="Medium",IF(B$9="+Major","YY",IF(B$9="+Mo derate","Y",IF(B$9="+Minor","O",IF(B$9="Negligible ","0",IF(B$9="-
Minor","O",IF(B$9="- Moderate","N",IF(B$9="- Major","NN","0"))))))))

=IF($B$3="Low",IF(B$9="+Major","Y",IF(B$9="+Modera te","O",IF(B$9="+Minor","O",IF(B$9="Negligible","0 ",IF(B$9="-
Minor","O",IF(B$9="- Moderate","O",IF(B$9="- Major","N","0"))))))))

Appreciate the help in advance
Rebecca