| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with OR function
On Aug 28, 10:44 am, Bob wrote:
Thanks for your suggestion! What I was looking for is: =OR(I2="Ignore",I2="Not Feasible") Thanks again, Bob "Noob Jedi" wrote: On Aug 28, 9:46 am, Bob wrote: I'm sure I'm doing something silly, but the following formula is evaluating to #VALUE! instead of TRUE or FALSE (depending on what is contained in cell I2): =I2=OR("Ignore","Not Feasible") Can someone kindly tell me how to fix my formula? Thanks. Sorry, should've given you my formula with it: =IF(OR(I2="Ignore",I2="Not Feasible"),TRUE, FALSE)- Hide quoted text - - Show quoted text - It's initially the same thing. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DBSUM function but with function as criterion, not a range | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Threaded Mode
