基本函數介紹

If


iserr


find


replace


實例應用

-- GB 轉 MB
=IF(ISERR(FIND("G",G2)),REPLACE(G2,FIND("M",G2),2,""),REPLACE(G2,FIND("G",G2),2,"")*1024)

-- MB 轉 GB
=IF(ISERR(FIND("G",G2)),REPLACE(G2,FIND("M",G2),2,"")/1024,REPLACE(G2,FIND("G",G2),2,""))