Snasui Excel Forum

Hi Dear,

I need your help how to write formula to convert weight and height in excel

I also attached a sample

Thank in advance

..

It does feel a little bit weird for me about the measurement that you need to convert.


B2
=IFERROR(LEFT(A2,AGGREGATE(15,6,SEARCH({"kg","g"},A2),1)-1)*LOOKUP(0,SEARCH({"kg","g"},A2)*{0,-1},{1,1000}),A2)

D2
=IFERROR(LEFT(C2,AGGREGATE(15,6,SEARCH({"cm","m"},C2),1)-1)*LOOKUP(0,SEARCH({"cm","m"},C2)*{0,-1},{1,100}),C2)

Norkaz

thank you but is there any solutions not complex?

sna wrote: Thu Dec 16, 2021 2:15 pm thank you but is there any solutions not complex?

B2
=IF(ISNUMBER(A2),A2,IF(COUNT(SEARCH({"k"},A2)),--LEFT(A2,LEN(A2)-2),LEFT(A2,LEN(A2)-1)*1000))

D2
=IF(ISNUMBER(A2),C2,IF(COUNT(SEARCH({"c"},C2)),--LEFT(C2,LEN(C2)-2),LEFT(C2,LEN(C2)-1)*100))

Norkaz

thank you