将表格中经纬度转换成小数格式数据是42°28‘30.85,在表格中写为42.283085用=INT(A2)+INT(A2*100-INT(A2)*100)/60+INT(A2*10000-INT(A2*100)*100)/3600后发现此式只计算到42.2830,剩下的被忽略,请问该怎么更改公式或
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/16 23:00:54
![将表格中经纬度转换成小数格式数据是42°28‘30.85,在表格中写为42.283085用=INT(A2)+INT(A2*100-INT(A2)*100)/60+INT(A2*10000-INT(A2*100)*100)/3600后发现此式只计算到42.2830,剩下的被忽略,请问该怎么更改公式或](/uploads/image/z/14054427-27-7.jpg?t=%E5%B0%86%E8%A1%A8%E6%A0%BC%E4%B8%AD%E7%BB%8F%E7%BA%AC%E5%BA%A6%E8%BD%AC%E6%8D%A2%E6%88%90%E5%B0%8F%E6%95%B0%E6%A0%BC%E5%BC%8F%E6%95%B0%E6%8D%AE%E6%98%AF42%C2%B028%E2%80%9830.85%2C%E5%9C%A8%E8%A1%A8%E6%A0%BC%E4%B8%AD%E5%86%99%E4%B8%BA42.283085%E7%94%A8%3DINT%28A2%29%2BINT%28A2%2A100-INT%28A2%29%2A100%29%2F60%2BINT%28A2%2A10000-INT%28A2%2A100%29%2A100%29%2F3600%E5%90%8E%E5%8F%91%E7%8E%B0%E6%AD%A4%E5%BC%8F%E5%8F%AA%E8%AE%A1%E7%AE%97%E5%88%B042.2830%2C%E5%89%A9%E4%B8%8B%E7%9A%84%E8%A2%AB%E5%BF%BD%E7%95%A5%2C%E8%AF%B7%E9%97%AE%E8%AF%A5%E6%80%8E%E4%B9%88%E6%9B%B4%E6%94%B9%E5%85%AC%E5%BC%8F%E6%88%96)
将表格中经纬度转换成小数格式数据是42°28‘30.85,在表格中写为42.283085用=INT(A2)+INT(A2*100-INT(A2)*100)/60+INT(A2*10000-INT(A2*100)*100)/3600后发现此式只计算到42.2830,剩下的被忽略,请问该怎么更改公式或
将表格中经纬度转换成小数格式
数据是42°28‘30.85,在表格中写为42.283085用=INT(A2)+INT(A2*100-INT(A2)*100)/60+INT(A2*10000-INT(A2*100)*100)/3600后发现此式只计算到42.2830,剩下的被忽略,请问该怎么更改公式
或者写为422830.85,只是公式又该是什么呢?
将表格中经纬度转换成小数格式数据是42°28‘30.85,在表格中写为42.283085用=INT(A2)+INT(A2*100-INT(A2)*100)/60+INT(A2*10000-INT(A2*100)*100)/3600后发现此式只计算到42.2830,剩下的被忽略,请问该怎么更改公式或
B2列计算度=INT(A2) C2列计算分=INT((A2-INT(A2))*100) D2列计算秒==(A2-INT(A2)-INT((A2-INT(A2))*100)/100)*10000 你要转换成十进制度的话,E2列直接输入 ==INT(A2)+INT((A2-INT(A2))*100)/60+(A2-INT(A2)-INT((A2-INT(A2))*100)/100)*10000/3600
如果你直接单纯地想把42.283085改写成42°28‘30.85的话,
=INT(A2) & “°” & INT((A2-INT(A2))*100) & “′” & (A2-INT(A2)-INT((A2-INT(A2))*100)/100)*10000 & “″”