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.


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'