'fllll- \ hll l_J.\\..I llIL/uLIL. not relative} Create a formula in cells E3:E4, E:E8 L start with \"agent value by placing an x in that uses an IF statement to determine if cell as and then replace the formula in E6 the results are calculated. following step 8b of the instructions . d. Repeat the steps in c for EF-EB I. If the cell In Column 13 on the Repeat me steps in c for E3 and E4 same row is \"\" {Blank} then ' _Then do steps Br: 39 reference the input cell in the same row in Column D, else use the appropriate nance function to calculate the results ii. The formula in E3 and E4 should be put in an IFERRORU function in case excel is unable to calculate the interest or term. iii. The arguments used in each nance function must reference column E ldo not reference column Di. iv. For example the formula in E3 will look like this =lFERRU RIIIFlE33="",Annual_|nterest_Rate,RATE lm'l'ears* mPerYear,umt, mP'v',m FV,mBegEnd)*mPer'fear},Ul