If And Or
did a mix on above:
=IF(OR(COUNTIF(A1:A2,P)=2,AND(COUNTIF(A1:A2,P)=1,C OUNTIF(A1:A2,E)=1)),F,"")
insert, name, define: P as: ={"pass"} E as: ={"exempt"} F as:
={"full award"}
"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
|