Here is the example:
The column on the left (C) simply states a typical growth (e.g. 10% by the power of the month or year, which is column b)
Column D, which is kind of manual says, that i want to calculate something different, and that is the growth is actually declining at some point (10% X 75% by the power of 1 etc., but that 1 starts only when the condition starts, which I guess means some kind of offset formula).
So essentially, I want to create an IF formula, where once a certain threshold is met, the formula will behave differently but still count that power from the beginning (i.e. from 1 to 2 to 3 etc.)
Any help would be great!
The column on the left (C) simply states a typical growth (e.g. 10% by the power of the month or year, which is column b)
Column D, which is kind of manual says, that i want to calculate something different, and that is the growth is actually declining at some point (10% X 75% by the power of 1 etc., but that 1 starts only when the condition starts, which I guess means some kind of offset formula).
So essentially, I want to create an IF formula, where once a certain threshold is met, the formula will behave differently but still count that power from the beginning (i.e. from 1 to 2 to 3 etc.)
Any help would be great!