[SOLVED] How to calculate accumulate amortization, Residual value, and VLook up

[jackson_hollon]

Hello,

I have a royalty calculation spreadsheet. I would like to ask for help with the following formula.

1) I need to calculate the accumulate amortization as of B10.
2) I need to find the Residual value
3) The formula on O3 need to be able to auto lookup the corresponding product with the royalty period and calculate the monthly cost. Now the formula is a fixed formula, the end result is correct but I can not add row and fill it cross.

Attached is the sample.

Greatly appreciate your help.

Jackson

[samba_ravi]

see the attached file

[jackson_hollon]

Siva,

Thanks for the help.

Formula 3 for looking up the date to assign the value is great except after I add more data, the formula doesn't work. Is there a way the formula looks up the table on A1 to G7 and assign the expenses? Please see my sample.

Thanks again for the help.

Jackson

[samba_ravi]

I can't understand
How your desired result would be

[jackson_hollon]

Siva,

Thanks for the great help.

I want to be able to run the formula to N34. Thank you again for the help.

Jackson

[samba_ravi]

The simple way is insert columns between F & G and change Row 2 and 3 according to your requirement

[jackson_hollon]

Siva,

OK. Thank you for the help.

Jackson