If statement nested
I do apologise, was a pure mistake as someone disturbed me in office here and
I was uncertain I had posted, IE hit wrong key and could not see it on forum
at time (May have been a delay) (Hence reposted) my fault and sincere aplogies
Regards
Steve
"Mike H" wrote:
And because you posted the same question with a different subject line I
wasted my time answering a question you already had an answer to. Please do
not double post the same question it's irritating to those who freely give
their time to help out.
Mike
"k11ngy" wrote:
Thanks VM for your help
Kind regards
Steve
"Stefi" wrote:
=IF(AND(OR(A1="Pass",A1="Exempt"),OR(A2="Pass",A2= "Exempt")),"FULL AWARD","")
Regards,
Stefi
€˛k11ngy€¯ ezt Ć*rta:
Hi
I need to Nest If/And/Or together and having trouble
I need to:
If A1=Pass or Exempt and A2 = pass or exempt, FULL AWARD, else ""
Cant seem to fathom this one
Thanks for help
|