formula of index ecconomics11
Answers
Answered by
0
☺️
━━━━━━━━━━━━━━━━━━━For example, the formulaCELL("width",INDEX(A1:B2,1,2)) is equivalent to CELL("width",B1). The CELL function uses the return value ofINDEX as a cell reference. On the other hand, a formula such as 2*INDEX(A1:B2,1,2) translates the return value of INDEX into the number in cell B1.
━━━━━━━━━━━━━━━━━━━
━━━━━━━━━━━━━━━━━━━For example, the formulaCELL("width",INDEX(A1:B2,1,2)) is equivalent to CELL("width",B1). The CELL function uses the return value ofINDEX as a cell reference. On the other hand, a formula such as 2*INDEX(A1:B2,1,2) translates the return value of INDEX into the number in cell B1.
━━━━━━━━━━━━━━━━━━━
Similar questions