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
=IF(OR(AQ2="L",AQ2="kg"),IFERROR(1/(1/(N2*O2)),""),IF(OR(AQ2={"U","m2","m","2U"}),0,""))
Bookmarks