Calculating Value Advanced
There is an Excel file that teaches how to perform the Calculating Value Advanced operation.
Excel Professional Calculating Value Advanced
This workbook demonstrates calculating value advanced using VBA macros on a 13-row data layout.
Hope it is useful.