| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF and OR Functions
Please tell me what's wrong with this formula?
=IF(OR(A1:A88=14,41,38,20,46,18,22,24,12,11,59,48) ,"YES","NO") I'm trying to create a function that will look for numbers "14, 41, 38, 20,46, 18, 22, 24, 12, 11, 59, or 48" within the column range A1:A88. If these numbers appear in the column range, then "Yes", otherwise "No." Thank you for your help. (P.S. Using Excel version 2003) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF and OR Functions
=IF(SUM(COUNTIF(A1:A88,{14,41,38,20,46,18,22,24,12 ,11,59,48}))0,"YES","NO")
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Trea" wrote in message ... Please tell me what's wrong with this formula? =IF(OR(A1:A88=14,41,38,20,46,18,22,24,12,11,59,48) ,"YES","NO") I'm trying to create a function that will look for numbers "14, 41, 38, 20,46, 18, 22, 24, 12, 11, 59, or 48" within the column range A1:A88. If these numbers appear in the column range, then "Yes", otherwise "No." Thank you for your help. (P.S. Using Excel version 2003) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF and OR Functions
Thank you Bob - You are the Best!!
"Bob Phillips" wrote: =IF(SUM(COUNTIF(A1:A88,{14,41,38,20,46,18,22,24,12 ,11,59,48}))0,"YES","NO") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Trea" wrote in message ... Please tell me what's wrong with this formula? =IF(OR(A1:A88=14,41,38,20,46,18,22,24,12,11,59,48) ,"YES","NO") I'm trying to create a function that will look for numbers "14, 41, 38, 20,46, 18, 22, 24, 12, 11, 59, or 48" within the column range A1:A88. If these numbers appear in the column range, then "Yes", otherwise "No." Thank you for your help. (P.S. Using Excel version 2003) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Conversion from Spreadsheet Toolkit functions (ESSV....) to EssBase API functions | Excel Programming | |||
| excel functions and User defined functions | Excel Programming | |||
Linear Mode
