If And Or
found this info, not sure if way of shortening these examples up further.
another way of doing it.. something took while to get, to be able to add
many names to one spot while not using any more space:
create a defined name e.g. this formula: insert, name, defined, using P
as a made up name same as in this formula, enter: ={"pass";"exempt"}
=IF(AND(OR(A1={"pass","exempt"}),OR(A2={"pass","ex empt"})),"full award","")
=IF(SUMPRODUCT(--ISNUMBER(FIND(P,A1:A2)))0,"full award","")
=IF(AND(SUMPRODUCT(--ISNUMBER(FIND(P,A1)))0,SUMPRODUCT(--ISNUMBER(FIND(P,A2)))0),"full award","")
this will allow you to change values externally, or add many values to same
formula, without changing the formula.
"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
|