当前位置:首页>维修大全>综合>

excel三个数值怎么对比大中小(excel中三个数比较大小的方法)

excel三个数值怎么对比大中小(excel中三个数比较大小的方法)

更新时间:2025-08-25 09:10:22

excel三个数值怎么对比大中小

d1=IF(A1=MAX($A1:$C1),"大",IF(A1=MIN($A1:$C1),"小","中")

)e1=IF(B1=MAX($A1:$C1),"大",IF(B1=MIN($A1:$C1),"小","中")

)f1=IF(C1=MAX($A1:$C1),"大",IF(C1=MIN($A1:$C1),"小","中"))

更多栏目