looking for some solutions? You are welcome.

SOLVED: Multiple If Or And statements

Daniel Montgomery:

I am looking to string together a couple of different If(or(and statements together. Basically to segregate the alphabet out into 3 different sections for one of the and requirements. A-G, H-M & N-Z My first one (shown below) works fine. Gives me the desired result when E4 meets one of the letter requirements specified requirements;

=IF(OR((AND(B4="Operational",LEFT(E4,1)="A"),AND(B4="Operational",LEFT(E4,1)="B"),AND(B4="Operational",LEFT(E4,1)="C"),AND(B4="Operational",LEFT(E4,1)="D"),AND(B4="Operational",LEFT(E4,1)="E"),AND(B4="Operational",LEFT(E4,1)="F"),AND(B4="Operational",LEFT(E4,1)="G")),"Operations Database 1 A-G","")

I then tried to tag on another if(or(And statement and receive a #value error.

=IF(OR((AND(B4="Operational",LEFT(E4,1)="A"),AND(B4="Operational",LEFT(E4,1)="B"),AND(B4="Operational",LEFT(E4,1)="C"),AND(B4="Operational",LEFT(E4,1)="D"),AND(B4="Operational",LEFT(E4,1)="E"),AND(B4="Operational",LEFT(E4,1)="F"),AND(B4="Operational",LEFT(E4,1)="G")),"Operations Database 1 A-G",""),IF(OR(AND(B4="Operational",LEFT(E4,1)="H"),AND(B4="Operational",LEFT(E4,1)="I"),AND(B4="Operational",LEFT(E4,1)="J"),AND(B4="Operational",LEFT(E4,1)="K"),AND(B4="Operational",LEFT(E4,1)="L"),AND(B4="Operational",LEFT(E4,1)="M")),"Operations Database 1 H-M",""))

Any thoughts?



Posted in S.E.F
via StackOverflow & StackExchange Atomic Web Robots
Share:

No comments:

Recent