# Formula with multiple if conditions

1. ## Formula with multiple if conditions

Hi,

Need formula with multiple conditions.

Excel file attached with necessary details.

Pl. help.

Thanks,
Nagesh.  Register To Reply

2. ## Re: Formula with multiple if conditions

in F4
=IF(AND(OR(B4="G",B4="B"),C4>=100,C4<=109,ISNUMBER(SEARCH(D4,"PCNF"))<>0,LEFT(L4,1)>="1",LEFT(L4,1)<="4"),E4,"")
and copy down the column

Not sure what you mean about Stage 2 formula (Column G).  Register To Reply

3. ## Re: Formula with multiple if conditions

In F4 ``Please Login or Register  to view this content.``  Register To Reply

4. ## Re: Formula with multiple if conditions

Thank you Special-K & Topley

Seems everything perfect with both the formulas but while checking the condition Sl. No.4, it should check / match the order numbers in Columns A Vs. K and then reference should be entire L column.

Pl. do the needful.

Nothing to do with Stage 2 formula.  Register To Reply

5. ## Re: Formula with multiple if conditions

I dont understand this, it doesnt say anything about column L in the spreadsheet?

but while checking the condition Sl. No.4, it should check / match the order numbers in Columns A Vs. K and then reference should be entire L column.  Register To Reply

6. ## Re: Formula with multiple if conditions

Try

=IF(ISNUMBER(LEFT(VLOOKUP(A4,\$K\$4:\$L\$29,2,0))+0),IFERROR(IF(AND(OR(B4="B",B4="G"),AND(C4>=100,C4<=109),ISNUMBER(SEARCH("PCNF",D4)),AND(LEFT(VLOOKUP(A4,\$K\$4:\$L\$29,2,0))+0>=1,LEFT(VLOOKUP(A4,\$K\$4:\$L\$29,2,0))+0<=4)),E4,""),""),"")

OR Special-k's:

=IFERROR(IF(AND(OR(B4="B",B4="G"),AND(C4>=100,C4<=109),ISNUMBER(SEARCH("PCNF",D4)),AND(LEFT(VLOOKUP(A4,\$K\$4:\$L\$29,2,0))>="1",LEFT(VLOOKUP(A4,\$K\$4:\$L\$29,2,0))<="4")),E4,""),"")  Register To Reply

7. ## Re: Formula with multiple if conditions

Thanks a Ton Topley. Both the above formulas are working as required.

Will keep working and let you know if i have any issue.  Register To Reply

8. ## Re: Formula with multiple if conditions  Register To Reply