| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statments: Want TRUE if a value = any of the given values
How do I make an if statment that says: If Value A2 is equal to any of
the Values in Row 4 (F4:IV4), then it is true, otherwise false. I was putting: =IF(A2=Sheet1!F4:IV4,"1","0"), but it doesn't seem to recognize the simple F4:IV4 as "any of these values is true". Thanks, Kerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I put in the IF function only integer as true values? | Excel Worksheet Functions | |||
| if multiple values same/others different, return true | Excel Discussion (Misc queries) | |||
| Summing values if conditions are true | Excel Worksheet Functions | |||
| Summing Values that are True and Not Rounded | Excel Discussion (Misc queries) | |||
| Multiple If True Values? | Excel Discussion (Misc queries) | |||
Threaded Mode
