--- title: "Conditional Expressions in Excel" description: "In this article I have described how to used conditional expressions in excel sheet. Conditions are true or false and making logical comparisons betwe" author: "AVADHESH PATEL" published: 2013-02-25 updated: 2019-09-07 canonical: https://www.mindstick.com/articles/1154/conditional-expressions-in-excel category: "excel" tags: ["excel"] reading_time: 1 minute --- # Conditional Expressions in Excel In this [article](https://yourviews.mindstick.com/view/81489/kashmir-now-after-an-year-of-abrogation-of-article-370) I have described how to used conditional expressions in [excel sheet](https://www.mindstick.com/forum/23040/to-import-excel-sheet-into-sql-database). Conditions are [true or false](https://www.mindstick.com/forum/160329/how-can-you-convert-a-value-to-a-boolean-true-or-false-in-javascript) and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF [function](https://www.mindstick.com/articles/43970/purchase-suitable-wedding-dresses-for-your-wedding-function) to create conditional formulas.\ For example if you want to check simple [condition](https://www.mindstick.com/forum/12711/select-query-with-and-condition) which have given below then apply given [formula](https://yourviews.mindstick.com/view/81488/usa-needs-masks-for-all-formula-in-corona-pandemic) ![Conditional Expressions in Excel](https://www.mindstick.com/mindstickarticle/26913d46-f115-4c99-a7dd-6f70d058d759/images/9199a2c3-704a-4985-9aad-6494a53614a0.png) Now apply condition using formula as below. Put “Logical Formula” column value into “Result” proceeding with “=” sign. For example write 5=6 as =5=6 and press enter button. ![Conditional Expressions in Excel](https://www.mindstick.com/mindstickarticle/26913d46-f115-4c99-a7dd-6f70d058d759/images/5d7f7829-d2c2-4593-b0fa-7cd706c2ba51.png) ##### AND, OR, and NOT functions and operators Used AND, OR and NOT [operators](https://www.mindstick.com/articles/13159/operating-press-brakes-an-ultimate-guide-for-brake-operators) as conditional statement as below image. Used “[Logical Expression](https://answers.mindstick.com/qa/31222/which-process-makes-different-logical-expression-looks-identical)” value into “Result” column with proceeding “=”. For example “AND(A2>A3, A2A3, A2