# if formula based on several criteria to extract data based on conditions

1. ## if formula based on several criteria to extract data based on conditions

I have a workbook that split qty based on criteria.

That is if value of column AQ statistics value is either kg,u,m2,2u as criteria for formula in column Y ,qty1 header either to extract the qty in column w .

but if the criteria is L in column AQ THEN take value of column N multiply value of column O, otherwise take the value of column W if the VALUE shown in column AQ are u,m2,2u . if kg is shown in column AQ , then do nothing.

So far trying formula as below but need some adjustments ``Please Login or Register  to view this content.``  Register To Reply

2. ## Re: if formula based on several criteria to extract data based on conditions ``Please Login or Register  to view this content.``
is it column AW or Column AQ  Register To Reply

3. ## Re: if formula based on several criteria to extract data based on conditions

Sorry it is column AQ instead of AW  Register To Reply

4. ## Re: if formula based on several criteria to extract data based on conditions

TRY
=IF(AQ2="L",IFERROR(1/(1/(N2*O2)),""),IF(OR(AQ2={"U","m2","2U"}),W2,""))
If it not works, show your expected result and re attach the file  Register To Reply

5. ## Re: if formula based on several criteria to extract data based on conditions

Thank you worked as requested  Register To Reply