=IF(R2C2=1,"はい","いいえ")
=IF(R2C2=1,"はい",IF(R2C2=0,"いいえ","???"))
=IF(OR(R2C2=1,R4C2=1),"はい","いいえ")
=IF(AND(R2C2=1,R4C2=1),"はい","いいえ")
点数範囲 | 評価名称 |
---|---|
90点以上 | 優 |
75~89点 | 良 |
50~74点 | 可 |
50点未満 | 不可 |
=IF(R2C2>=90,"優",IF(R2C2>=75,"良",IF(R2C2>=50,"可","不可")))
=IFS(R2C2>=90,"優",R2C2>=75,"良",R2C2>=50,"可",TRUE,"不可")
評価ランク | 得点 |
---|---|
A | 100 |
B | 80 |
C | 60 |
D | 40 |
E | 20 |
上記以外 | 0 |
=SWITCH(R2C2,"A",100,"B",80,"C",60,"D",40,"E",20,0)