Hi...

I have two columns which contain an amount data (currency value) while the other contain duration like a tenor (6 month, 1 year etc...) also i have another column which is to calculate the currency data with the tenor, how do i go about it, like need a calculation format..?

and how do i calculate it interest too per annual