[Excel] 林知穎's Question



  1. G1 的formula输入以下函数
    2.             
=IF(OR(AND(A1>=750,A1<=1499),AND(B1>=750,B1<=1499)),0.6,
IF(OR(AND(A1>=1500,A1<=2249),AND(B1>=1500,B1<=2249)),0.8,
IF(OR(AND(A1>=2250,A1<=2259),AND(B1>=2250,B1<=2259)),1,
IF(OR(A1>=2260,B1>=2260),1.2,"没有满足任何条件"
))))
  2. 再copy G1到G2 to G28



  3. 完成



Source: ---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.

© 2023 sunnypeaceisland.com