excel - Microsoft Excel - If、AND & OR 语句

Question

您好，我正在尝试在 Microsoft Excel 中编写地 block 大小计算，以确定地 block 是“小”、“中”、大还是“太大”。

它与底部 MyHermes 网站上的非常相似(https://www.myhermes.co.uk/help/parcel-size.html)

这是我的代码。

谢谢布赖恩

=IF(OR(B4<=45) AND (C4<=35) AND (D4<=16) AND (E4<=2), ”SMALL”,

IF(OR(B4>45 AND <61) AND (C4>35 AND <47) AND (D4>16 AND >47) AND(E4>2 AND <21),”MEDIUM”,

IF(OR(B4>60 AND <101) AND (C4>46 AND <101) AND (D4>46 AND >101) AND(E4>20 AND <31),”LARGE”,"TOO BIG",)))

Answer 1

B4>45 AND <61是多余的；更改为 B4<=61和所有其他人。您的 AND/OR 语法格式错误。

=IF(and(B4<=45, C4<=35, D4<=16, E4<=2), "SMALL",
 IF(and(b4<=61, C4<=47, D4<=47, E4<=21), "MEDIUM",
 IF(and(B4<=101, C4<=101, D4<=101, E4<=31), "LARGE", "TOO BIG")))