| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiple OR function
Is there some way to consolidate a function such as this:
=IF(OR(A1=5,B1=5,C1=5,D1=5,E1=5),5,0)? I want to see if any one of a non-contiguous range of cells is equal to a fixed value. I would like to input the fixed value only one time into the function if possible. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) | |||
| Need Function for adding rows on multiple sheets... struggling rookie ;) Thanks. | Excel Worksheet Functions | |||
| Sum function on multiple date fields | Excel Worksheet Functions | |||
| SUMIF(AND) FUNCTION | Excel Worksheet Functions | |||
Threaded Mode
