Excel Basics for Finance - Boston College

We can then rewrite the formula in cell B5 as “=B4*(1+B1),” so that the formula now refers to the interest rate value in Cell B1. Writing the formula in this form has a further advantage: Instead of typing in the reference “B1”, we can write “=(B4*1+” and then click on Cell B1 and add a close parentheses ). ................
................