例如将一列数据进行离散化,将满足某个范围内的数值映射成字母,在excel中如下操作
IF(E2>=1204.84,"C4",IF(E2>=1055.31,"C3",IF(E2>=793.19,"C2",IF(E2>0,"C1"))))
posted on 2018-08-18 10:20 乐晓东随笔 阅读(1237) 评论(0) 编辑 收藏 举报