Or excel formula 216610-Excel formula if or statement
In the embedded Excel workbook below insert a formula (in the grey cells in column E), that returns the text 'Yes', when a product SKU should be reordered, based on the following criteria If Stock on hand is less than ,000 AND Demand level is 'High' If the above conditions are met, return 'Yes', otherwise, return 'No' Here's is an example of the IF OR formula in the simplest form =IF (OR (B2="delivered", B2="paid"), "Closed", "Open") What the formula says is this If cell B2 contains "delivered" or "cancelled", mark the order as "Closed", otherwise "Open" Excel formulas and usage facinates me a lot I work with data so ur examples help me a lot Thanks Reply Krishnakumar 21 Apr, 19 at 149 am Hey champ, I need your help to resolve my query I want to make the criteria dynamic by getting the input from the user using slicer How To Create An Excel Formula In Notepad Excel form...