If And Or
slight correction:
=IF(AND(OR(A1=P,A1=E),OR(A2=P,A2=E)),F,"")
=IF((OR(A1=P,A1=E))*(OR(A2=P,A2=E)),F,"")
"k11ngy" wrote:
Trying to nest a statement together but have problems
I need to:
If A1 and A2 = pass then Full award, Else ""
I also need to nest in for example
If A1 = pass or exempt and a2 = Pass, Exempt then full award else ""
Cant seem to fathom it
Thanks for help
Steve
|