more than 7 nested IF(AND) statements in formula - VBA? **NEWBIE**
If I understand your formula correctly, I think it can be reduced to:
=MIN(J14,OFFSET(J17,MATCH(M19,G17:G25,0)-1,0))
The MATCH() function replaces each of your (M19=G17, M19=G18, ...)
conditions and then returns the value in column J for the match in
column G and then uses its value only if it is less than J14...
|