| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with OR function
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with OR function
Try this:
=OR(I2="Ignore",I2="Not Feasible") -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with OR function
Michael,
Thanks! Bob "Michael" wrote: Try this: =OR(I2="Ignore",I2="Not Feasible") -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with OR function
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. What is your complete purpose of the formula? It looks like you may have to use =if(or( in your formula. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with OR function
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) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with OR function
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) |
|
#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. |
| Reply |
| 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 | |||
Hybrid Mode
