Transforming Formula Conditionally
There is an Excel file that teaches how to perform the Transforming Formula Conditionally operation.
Excel Template for Transforming Formula Conditionally
This workbook demonstrates transforming formula conditionally using VBA macros on a 11-row data layout.
Hope it is useful.