OR
Returns TRUE if at least one of the conditions is met: free shipping for a large order or for a loyalty card.
OR(logical1, [logical2], ...)- [ ]optional part
- logical1
- The first condition, for example B2>=3000.
- logical2
- The second condition. You can add more.Optional
Return value
TRUE if at least one condition is met, and FALSE if none is.
Examples
Free shipping
fx
A
B
C
D
E
1
2
3
4
5
6
7
8
Order
Amount, $
Card
Shipping, $
ORD-1041
4200
No
ORD-1042
1800
Yes
ORD-1043
2500
No
ORD-1044
3000
Yes
ORD-1045
950
No
Sheet1
Details
OR takes several conditions separated by commas. One true condition is enough to make the answer TRUE. You get FALSE only if none is met.
Like AND, the function is usually placed inside IF, to get the value you need instead of TRUE and FALSE.
Common mistakes
- Several options for one value are written as separate comparisons: OR(A2="Boston",A2="Denver"), not A2="Boston","Denver".
- OR and AND get mixed up: “the order is over 3,000 and there’s a card” calls for AND, not OR.