AND, OR, NOT Function Generator
AND returns TRUE only if all arguments are TRUE. OR returns TRUE if any argument is TRUE. NOT inverts a boolean. Fundamental for complex IF conditions.
Syntax
=AND(logical1, ...) =OR(logical1, ...) =NOT(logical1)Try it — generate a AND / OR / NOT formula
Examples
Between two values
=IF(AND(A2>=10, A2<=100), "In range", "Out")TRUE only if both conditions hold.
Any of several categories
=IF(OR(B2="VIP", B2="Gold", B2="Platinum"), "Premium", "Standard")OR matches any listed value.
Exclude weekends
=IF(NOT(WEEKDAY(A2,2)>5), "Weekday", "Weekend")NOT flips the logic.
Tips
- ✓Use * for AND with numbers: (A>0)*(B>0) is TRUE (1) only if both TRUE.
- ✓Use + for OR: (A>0)+(B>0) returns 0/1/2.
- ✓IFS function often cleaner than nested IF(AND(...)).
Related Formulas
Nested IF
Nested IF formulas let you test multiple conditions and return different values ...
IFS
IFS evaluates conditions in order and returns the value for the first TRUE. Clea...
IFERROR
IFERROR wraps a formula and returns a fallback value when the formula throws an ...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free