我想set條formula係between 幾至幾range就等如幾多mark:
Range = Mark
1-10 = 40
11-20 = 30
21-30 = 20
31-40 = 20
41-50 = 10
51 or above = 0
係米用if 同 and set 家? 條formula係點?
Thanks!
Excel formula setting (if 同 and)?? URGENT
2007-10-09 2:19 am
回答 (2)
2007-10-09 5:15 am
✔ 最佳答案
假設你的分數在A1，你可以在其也CELL輸入：=IF(A1>=51,0,IF(A1>=41,10,IF(A1>=31,20,IF(A1>=21,30,IF(A1>=11,40,IF(A1>=1,50))))))
2007-10-09 02:48:57 補充：
其他 cell ，not 其也cell
2007-10-10 2:00 am
我想到一個不用 IF 的 方法, 但我想先問清楚
1-10 = 40
11-20 = 30
21-30 = 20
31-40 = 20
41-50 = 10
51 or above = 0
21-30 應是 20 還是30?
1-10 = 40
11-20 = 30
21-30 = 20
31-40 = 20
41-50 = 10
51 or above = 0
21-30 應是 20 還是30?
收錄日期: 2021-04-13 13:49:10
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071008000051KK02593