用EXCEL把角度转化成方位

用EXCEL把角度转化成方位

你要有一个区域数据才能实现自动显示操作的
假设度数的数据在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则可输入查询的度数了。

自己建立分级表，然后用LOOKUP索引。追问具体点追答供参考
=LOOKUP(46,{0,90,180,270},{"东","南","西","北"})&"风"