- ·上一篇:excel表格论坛之家怎么注册账号
- ·下一篇:excel表格怎么解锁区域锁定
excel表格长宽高怎么求面积
2024-08-09 15:18:22
1.EXCEL表格计算面积和体积
面积:
=LEFT(A54,FIND("*",A54)-1)*MID(A54,FIND("*",A54)+1,FIND("*",A54,FIND("*",A54)+1)-(FIND("*",A54)+1))
体积:
=LEFT(A54,FIND("*",A54)-1)*MID(A54,FIND("*",A54)+1,FIND("*",A54,FIND("*",A54)+1)-(FIND("*",A54)+1))*RIGHT(A54,LEN(A54)-FIND("*",A54,FIND("*",A54)+1))