Excel Formula Directory
Explore our comprehensive library of spreadsheet formulas with examples, use cases, and our interactive formula generator.
Showing 6 formulas in Logical
AND
=AND(A1>0, A1<10)Testing if all conditions are TRUE for logical operations
View formula detailsFALSE
=FALSE()Returning the logical value FALSE for conditional formulas
View formula detailsIF
=IF(A1>10, "High", "Low")Performing a conditional test and returning different values based on the result
View formula detailsNOT
=NOT(A1>10)Reversing the logical value of an expression
View formula detailsOR
=OR(A1>0, A1<-10)Testing if any condition is TRUE for logical operations
View formula detailsTRUE
=TRUE()Returning the logical value TRUE for conditional formulas
View formula detailsCan't find the formula you need?
Use our AI-powered Formula Generator to create custom formulas for any task. Simply describe what you want to calculate in plain language.
Popular formula requests:
- Calculate the sum of values when multiple conditions are met
- Extract specific text between two characters
- Look up values across multiple sheets with fallback options
- Calculate business days between two dates excluding holidays
Unlock the Full Power of Sheet Alchemy
Get access to all our formula generators, script generators, and conversion tools with a free Sheet Alchemy account.