Formula not working correctly
In Excel I have a document that has 3 sheets on sheet 1 I have the following formula in a cell where I want an "x" =IF(AND(Sheet3!B2>=Sheet3!BU5,(Sheet3!B2
Computers & Internet - Oracle - Database Enterprise Named User Plus
Answers & Comments
You need to change the =IF(AND to =IF(OR
Using AND is saying both conditions must be true. Using OR is saying either condition 1 or 2 need to be true
Try this link to create the formula
http://office.microsoft.com/en-us/excel/HP052001271033.aspx