Thread: more than 7 nested IF(AND) statements in formula - VBA? **NEWBIE**
View Single Post
  #4   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**
MIN() says to take the minimum value of all arguments.

OFFSET() says to pick up the data offset from the cell reference
specified. For example, OFFSET(A1,2,1) says to get the value that is
two rows below and 1 column to the right of cell A1.

Reply With QuoteReply With Quote