using nested If AND function?

[Mr Dean]

I am trying to create a formulae where the following table is true and the output as provided. Tried usin the nested if function but can not seem to make sense. Table will probably be 100 rows long and could have any combinations of numbers in them. Basically though if there is a recorded Critical regardless of other values it must always be sad, if there are and major or minor but no critical it must be neutral and if there are any minor but no major or critical it must be happy.

Thanks in advance

Critical	Major	minor	output
Any value >=1	Any value >=0	Any value >=0	sad
value =0	Any value >=1	Any value >=0	neutral
value =0	Any value >=0	Any value >=1	happy

 

[gaz_chops]

Maybe

=IF(A2,"Sad",IF(AND(B2<=0,C2),"Happy","Neutral"))

 

[Fluff]

How about
=IF(A2>=1,"Sad",IF(B2>=1,"Neutral","Happy"))

 

[Mr Dean]

Thank you both for your quick responses. Both work equally well.

 

[Fluff]

Glad we could help & thanks for the feedback.