金山办公吧 关注:21贴子:20
  • 1回复贴,共1

大家一起来学习打卡,交流。

只看楼主收藏回复



IP属地:湖南1楼2022-03-17 15:41回复
    这个公式可以帮我优化一下吗?
    =IF(A1<3100,A1,IF(A1<3600,A1-500,IF(A1<4100,A1-1000,IF(A1<4600,A1-1500,IF(A1<5100,A1-2000,IF(A1<5600,A1-2500,IF(A1<6100,A1-3000,IF(A1<6600,A1-3500,IF(A1<7100,A1-4000,IF(A1<7600,A1-4500,IF(A1<8100,A1-5000,IF(A1<8600,A1-5500,IF(A1<9100,A1-6000,IF(A1<9600,A1-6500,IF(A1<10100,A1-7000,IF(A1<10600,A1-7500,IF(A1<11100,A1-8000,IF(A1<11600,A1-8500,IF(A1<12100,A1-9000,IF(A1<12600,A1-9500,A1-10000))))))))))))))))))))


    IP属地:安徽来自Android客户端2楼2022-04-12 10:35
    回复