if(and formula trouble

Hey guys,

Haven't been able to figure this out since yesterday. I was hoping for some help:

A1 = Total
B1 = Pass
C1 = No

What i'm trying to do is as follows:

If A1 = 0, then the entire result is N/T
If C1 > 1, then the entire result is U
If C1 = 0 and A1 (or B1) > 0, then the entire result is S.

Can't seem to figure out a good if/if(and statement for this. Any suggestions?

Thanks!!

Mehmetcik,

Hey, thanks very much for the suggestion. As soon as I wrote the post I had an idea which worked:

=IF(A1=0,"N/T",IF(AND(A1>1,B1>=0,C1>0),"U","S"))

Thanks!!