| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
OR function
Is there a way to shorten or compress the "OR" portion of this formula
=IF(OR(C5=N61,C5=N62,C5=N63,C5=N64,C5=N65,C5=N66,C 5=N67,C5=N68,C5=N69,C5=N70,C5=N71,C5=N72,C5=N73,C5 =N74,C5=N75,C5=N76,C5=N77,C5=N78,C5=N79,C5=N80,C5= N81,C5=N82,C5=N83),VLOOKUP(C5,Matrix!$A$2:$AB$28,M ATCH(B5,Matrix!$A$1:$AB$1,0),FALSE),Q60) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
Threaded Mode
