How do I increase the number at the end of every quarter over ten years?

[RSidhu]

I want to increase an expense only at the end of the 4th quarter. My years are columns and have q1 , q2, q3, q4 for ten years. how do i do that?
I was thinking using the mod function but not able to figure it out. any quick help will be truly appreciated. thank you

 

[jeffreyweir]

RSidhu: You'll have more luck getting a response if you post a sample file showing what your data layout looks like and what you want to achieve

 

[RSidhu]

Attached is the sample file. I want one formula such that the increase in amount is every 4th quarter for all years. thank you

 

[David Evans]

RSidhu -

Here's a solution using MOD() as you had requested. As usual with Excel there are numerous acceptable solutions, and this works; however, I think there are simpler methods, but a little formula elegance periodically is good for an analyst

 

[RSidhu]

Thank you, very helpful David

 

[John Jairo V]

Hi to all!

You can simply use this formula in C7 and copy it to the right:
=B7*(1+C8*(C5<>D5))

Blessings!

 

[RSidhu]

Thanks John!