紧急求知，在EXCEL中,如何在一个格子里计算四个数据,

来源：百度知道 编辑：UC知道 时间：2024/05/17 10:22:34
在EXCEL中,如何在一个格子里计算四个数据,如7.33,11.5,13.8,17.9这个是在同一格内,再减去7.30,11.30,13.00,17.00,怎么做
就是说7.33-7.30得出一个值,11.5-11.30得出一个值,13.8-13.00得出一个值,17.9-17.00得出一个值,然后这些值最后还是放在同一个单元格里面按顺序进行排列.

不是不能作出来，但EXCEL不是这么用的。
此外，是单纯的减去一个数后，再用逗号分隔各自的差值？还是对这些差值求和？
如果还是用逗号分隔差值，公式为：
=TEXT(LEFT(A1,FIND(",",A1)-1)-7.3,"#0.00")&","&TEXT(MID(A1,FIND(",",A1)+1,FIND("@",SUBSTITUTE(A1,",","@",2))-FIND(",",A1)-1)-11.3,"#0.00")&","&TEXT(MID(A1,FIND("@",SUBSTITUTE(A1,",","@",2))+1,FIND("@",SUBSTITUTE(A1,",","@",3))-FIND("@",SUBSTITUTE(A1,",","@",2))-1)-13,"#0.00")&","&TEXT(RIGHT(A1,LEN(A1)-FIND("@",SUBSTITUTE(A1,",","@",3)))-17,"#0.00")

如果是对差值求和，公式为：
=(LEFT(A1,FIND(",",A1)-1)-7.3)+(MID(A1,FIND(",",A1)+1,FIND("@",SUBSTITUTE(A1,",","@",2))-FIND(",",A1)-1)-11.3)+(MID(A1,FIND("@",SUBSTITUTE(A1,",","@",2))+1,FIND("@",SUBSTITUTE