用EXCEL把角度转化成方位
答案:2 悬赏:0 手机版
解决时间 2021-01-06 03:03
- 提问者网友：杀手的诗
- 2021-01-05 10:54
用EXCEL把角度转化成方位
最佳答案
- 五星知识达人网友：杯酒困英雄
- 2021-01-05 12:06
你要有一个区域数据才能实现自动显示操作的
假设度数的数据在A2单元格，则可在B2单元格输入公式：
=LOOKUP(MOD(360+A2,360)-1%%,{-0.01,33.75,56.25,123.75,146.25,213.75,236.25,303.75,326.25},{"东","东北","北","西北","西","西南","南","东南","东"})&"风"
即可在B2显示对应A2度数的风向了。追问
追答=LOOKUP(A2,{-12,11.25,33.75,56.25,78.75,101.25,123.75,146.25,168.75,191.25,213.75,236.25,258.75,281.25,303.75,326.25,348.75},{"N","NNE","NE","ENE","E","ESE","SE","SSE","S","SSW","SW","WSW","W","WNW","NW","NNW"})
若你有表格内的数据区域，公式将更简单，如下图，只要在B2单元格输入公式：
=LOOKUP(A2,$E$2:$E$18,$D$2:$D$18)
即可。A2则可输入查询的度数了。
假设度数的数据在A2单元格，则可在B2单元格输入公式：
=LOOKUP(MOD(360+A2,360)-1%%,{-0.01,33.75,56.25,123.75,146.25,213.75,236.25,303.75,326.25},{"东","东北","北","西北","西","西南","南","东南","东"})&"风"
即可在B2显示对应A2度数的风向了。追问
追答=LOOKUP(A2,{-12,11.25,33.75,56.25,78.75,101.25,123.75,146.25,168.75,191.25,213.75,236.25,258.75,281.25,303.75,326.25,348.75},{"N","NNE","NE","ENE","E","ESE","SE","SSE","S","SSW","SW","WSW","W","WNW","NW","NNW"})
若你有表格内的数据区域，公式将更简单，如下图，只要在B2单元格输入公式：
=LOOKUP(A2,$E$2:$E$18,$D$2:$D$18)
即可。A2则可输入查询的度数了。
全部回答
- 1楼网友：拜訪者
- 2021-01-05 13:31
自己建立分级表，然后用LOOKUP索引。追问具体点追答供参考
=LOOKUP(46,{0,90,180,270},{"东","南","西","北"})&"风"
=LOOKUP(46,{0,90,180,270},{"东","南","西","北"})&"风"
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯