Your VBA Function receives a 5x6 array. We will call this array [A]. Your function analyzes each of the input values first based on the criteria below: a. If the value is greater than zero, it multiplies it by 2. b. If the value is equal to zero, it adds 5 to it. c. If the value is less than zero, it subtracts 8 from it. In doing so, the newly calculated values are stored in a new array called [B] within your function. Next, all of the values in array B are added to each other using a For/Next loop and the total value is returned to Excel Note: Make sure you use a multi-alternative decision block properly and don't forget to begin counting your array at 1,1