Forum Discussion
Formula help
=IF($G8="yearly",$Y8*(1+$H8),Y8*(1+$I8)) In this formula Y8 is a growth rate that changes every 12 months. How can i update the formula that it will move that cell reference every 12 cells? I hav...
Attached is an example of how VLOOKUP can refer to a year and retrieve from a table the associated growth rate. Your application may well (probably does) require modifications to that, but it illustrates the use of a table and VLOOKUP
- I'm targetting the correct growth rate already - what i need to be dynamic is the base figure the rate is applied to. Thanks for trying to help
