Excel Question???

Hi, this is my first post here on Forex Factory. I am currently making a compounding spreadsheet and can't figure out something.

I put the number 2000 in C2 and then go to C4 and type the equation =C2 to get the same value from C2 in C4.

I want all the cells under C4 to have the same value by changing C2. So when i change C2, everything from C4 and under becomes the value that is in C2.

If anyone can help me, it would be very helpful.

thank you

I'm not sure if this what you are looking for, but lets try this.
Type =$C$2 in C4 and then copy the C4 into all the cells below it (C5, C6...). After that if you change C2 it will also change the value in C4, C5... I hope that will help.

thanks, it works great