Need help: Grow a number every three months

[Tinka180185]

I would be so so grateful if you could help me with the following formula:

I would like to grow a number every three months by 100.
In my example the number of sales points grows every three months by 100.
So in January, we start with 1000 sales points, in April we have 1100, in July we have 1200 etc.
I have no idea what the correct formula is:/

I have attached the relevant file, the formulas has to me inserted in cells H7, I7 etc.

Would anybody be so kind and help?

[Phuocam]

H7: = 1000

Try this formula in I7 and copy across::

=IF(MOD(COUNT($H$7:H7),3)>0,H7,H7+100)

[Tinka180185]

Thank you so much!! However, the formula does not work Could you double check? Also, could you use the cell "C7" in the formula in case we change the number of salespoints to be added? THANK YOU SO MUCH!

[modytrane]

do you also want the monthly growth by % in columns D and E?
So in your example Feb would be 1,010 March would be 1,020 and April would jump to 1,100?
Also is monthly % growth compounded? It looks like you are compounding this. Just wanted to confirm.

[Tinka180185]

No i donīt , D7 and E7 have to be deleted.
So in my example the end result should be: Jan 1000, Feb 1000, March 1000, April 1100, May 1100, June 1100, July 1200, August 1200, September 1200, Oktober 1300, November 1300, December 1300.

Thanks for the clarification!

[samba_ravi]

or try
I7=$H7+INT(COLUMNS($I7:I7)/3)*100

copy and past toward right

[samba_ravi]

try I7=$H7+INT(COLUMNS($I7:I7)/3)*$C7

[Tinka180185]

IT WORKED!! Thank you so so much!! I am so grateful

[Tinka180185]

Last question: Which formula do I post in U7 and V7 (numbers for total year). The correct number in U7 should be 1600 and in v7 1900

[modytrane]

Formula suggested in #2 above with following change works as well.

[loginjmor]

Hi -

Try this:

=H7*(1+$D7)+IF(MOD(COUNT($H$7:H7)+1,3),0,$C$7)

[Tinka180185]

Sorry, but this one is still not working:/

[samba_ravi]

I think U7 should be 1300+400=1700 and V7 should be 1700+400=2100
isn't it

[Tinka180185]

Sorry you are right

[loginjmor]

Can you describe what you mean by "not working"? How do you know it's not working? What are the numbers you are expecting to see? I think if you provide that, we can better help you.

[Tinka180185]

Hi -

Try this:

=H7*(1+$D7)+IF(MOD(COUNT($H$7:H7)+1,3),0,$C$7)

I also thank you for your help, however, the only formula that has been working is samba_ravis!

[Tinka180185]

Sorry, i mean the system tells me "the formula is not correct" if I type in your formula.

[samba_ravi]

U7=sum({1,2,3,4}*3)*$c7*2+$h7*12-$C7*12
v7=sum({1,2,3,4}*3)*$c7*3+$h7*12-$C7*12

[Tinka180185]

Thank you! But why "1200! at the end? I get 16,800 as a result for u7:/

[Tinka180185]

Even with your changes the result is still not correct Iīm afraid. Itīs 6000!

[samba_ravi]

sorry try below on
U7=SUM({0,1,2,3}+1*4)*$C$7*3+$H7*12
V7=SUM({0,1,2,3}+2*4)*$C$7*3+$H7*12

[Tinka180185]

Thank you for your great help today!