assistance to merge two formulas as one formula

[JEAN1972]

I have data sheet where header column AS"Statistical Unit" is used as criteria to perform calculations in header column " U " Qty 1".

if criteria in columns AS is "U, "m2","m","2u" then this formula is applied =IF(OR(AS2={"U","m2","m","2U"}),SUBSTITUTE(LEFT(AB2,LEN(AB2)-2)," ","")+0,"")

However in columns "AS"Statistical Unit shows " L" then this formula is applied IFERROR(1/(1/(P5*Q5)),"")

Looking a way to merge these two formulas as one formula

Thanks if anyone can assist

[kvsrinivasamurthy]

In U2, then drag down

Please Login or Register  to view this content.

[JEAN1972]

Thank you for help. Working as requested