View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Randy Harmelink Randy  Harmelink is offline
external usenet poster
 
Posts: 122
Default 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...