Custom Column

Input: Sample file with base data.

Download sample input files here

Goal: Setup a workbook formula that pulls the data from the sample file. Report a custom column having one forth of amount for interest greater than 8.

Hint:

1.Select Range and apply condition where interest is greater than 8.

2.Select custom column, mapping should be done to first cell of amount column and divide it by 4 (if $A$2 is starting entry cell of amount column then write $A$2/4)

3.Report the column name with 'Updated Amount'