=IF(COUNTIF(E2,“Gbps”)>0,VALUE(SUBSTITUTE(E2," Gbps","")),IF(COUNTIF(E2,“Tbps”)>0,VALUE(SUBSTITUTE(E2," Tbps","")*1024),IF(COUNTIF(E2,“Mbps”)>0,VALUE(SUBSTITUTE(E2," Mbps","")/1024),IF(COUNTIF(E2,“kbps”)>0,VALUE(SUBSTITUTE(E2," kbps","")/1024/1024)))))
图例:判断不用单位,进行转换计算