IF, AND, OR statements

[wdw101]

I need help with a formula. It needs to do the following:

If AA12 = 0 AND AC12 = 0, then return AM2 or if AA12=0.27 and AC12=0.96, then return AM1.

Thanks for your help!

 

[bbott]

=if(and(aa12=0,ac12=0),am2,if(and(aa12=0.27,ac12=0.96),am1,""))

 

[gaz_chops]

Try
=IF(AND(AA12=0,AC12=0),AM2,IF(AND(AA12=0.27,AC12=0.96),AM1,""))