| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get IF(OR) formula to recognize multiple cells
I am using the formula
=IF(OR(A5={"a","a1","a2","a3","a4","x","x1","x2"," x3","x4","t","t1","t2","t3","t4","h","h1","h2","h3 ","h4","r","l"}),"X","") to place an "X" in the destination cell. How would I adapt this formula to include cells B5 through E5, and would also include the numbers 1 through 4 as part of the criteria? -- rwfster |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cells don't recognize formula | Excel Worksheet Functions | |||
| How do I recognize duplicate cells in multiple columns? | Excel Discussion (Misc queries) | |||
| How do I format a formula to recognize multiple comparison factors | Excel Worksheet Functions | |||
| How to format cells to recognize numbers like 1.1.1? | Excel Discussion (Misc queries) | |||
| How to make a cell recognize multiple text strings? | Excel Worksheet Functions | |||
Threaded Mode
