I have a worksheet which breaks down quantities from column AB2 based on column AS statisical unit consists of kg L,U,m,m3 2u .
on column u qty1 header using formula below
=IF(OR(AS2="L",AS2="kg"),IFERROR(1/(1/(P2*Q2)),""),IF(OR(AS2={"U","m2","m","2U"}),SUBSTITUTE(LEFT(AB2,LEN(AB2)-0)," ","")+0,""))
my issue that now the column U shows no more ea ,pks, in the digits. that 30.00EA OR 30.00PKS now reads 30,2 ,15 and so on.
column BC is the example that column U will show now .
Can anyone assists , the issue of the formula is in red as below.
Bookmarks