Problem RMZ Function

I'm not sure what RMZ means. The formula you have looks like it should translate directly into Excel:

1) Replace the variables with the desired values and prepend an equals sign on it: =1*((1+2)^3*2)/((1+2)^3-1) where C0=1, i=2, T=3
2) Enter the values into suitable cells and replace the variables with cell references =A1*((1+B1)^C1*B1)/((1+B1)^C1-1) where A1 contains the value for C0, B1 contains the value for i, and C1 contains the value for T.

If you are unfamiliar with writing formulas in spreadsheets (or Excel specifically), this might be a useful starting place: https://support.microsoft.com/en-us/...rs=en-us&ad=us

I put in the formula but it shows error ?

I also replaced it with right numbers but didnt work?

RMZ is a function to calculate
=B32*((1+B31)^B29*B31))/((1+B31)^-B29 -1);

You have a superfluous close bracket at the end of the numerator. Try:

=B32*((1+B31)^B29*B31)/((1+B31)^-B29 -1)

Glad we could help. Thanks for the feedback.