In a decision tables Excel worksheet, the formula in cell C11 is: =$B$2*MIN($B11,C$6) The formula is copied to cells C12:C16 and cells D11:H16. The formula in cell D13 will be:
Solution:
In the given formula, first term $B$2 has absolute reference for both row and column. In the second term, $B11 has absolute reference for column, and relative reference for row. C$6 has relative reference for column and absolute reference for row. When this formula is copied to cell D13, the reference is offset by one column to the right and two rows down. $B$2 will remain as it is. $B11 will change to $B13 and C$6 will change to D$6. The resulting formula for cell D13 is:
=$B$2*MIN($B13,D$6)