Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
hello,
Ok, I have a material cost in cell A1 - todays date in A2, the date the material will be delivered in A3, and an inflation value in A4 (%per annum). I need a formula that will work out what the material will cost when the material is delivered. eg. costs £100 today at a rate of 5%per annum it will cost £105 next year and £110.25 in two years. All input values are in seperate cells and can vary. Also it will have to cope with fractions of a year. Any ideas? Ciara |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
a formula to find total compound amount after given number of yea. | Excel Worksheet Functions | |||
Interest formula on Personal Line | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Are financial functions calculated based on compound interest? | Excel Worksheet Functions | |||
compound interest | Excel Worksheet Functions |