Excel分数转为百分数
参考:https://zhidao.baidu.com/question/1238911457905428779.html
思路:先将分数转为小数,再将小数转为百分数
=TEXT(LEFT(B10,FIND("/",B10)-1)/RIGHT(B10,LEN(B10)-FIND("/",B10)),"0.00%")
参考:https://zhidao.baidu.com/question/1238911457905428779.html
思路:先将分数转为小数,再将小数转为百分数
=TEXT(LEFT(B10,FIND("/",B10)-1)/RIGHT(B10,LEN(B10)-FIND("/",B10)),"0.00%")