I am attempting to calculate CRF from the inputs of Interest Rate(B4) and Number of Annuities(B5). This should be doable in excel, but I am struggling. I tried simply having a cell with the formula
=(B4(1+B4)^B5)/((1+B4)^B5)-1
and I get a Value error.
Is there possibly a function for...