what is the formula to find increment ?

[chandra1961]

i have 12 months from january to december , each month say Rs 100 as input
whenever january or april or july or october months ie every quarter i have
to increment rs 100,
for example when jan comes increment rs 100 to the cell other months no
icrement
for april comes only april incremented likewise every quarter

please reply

 

[Shane Devenshire]

Hi,

why don't you show us some dummy data, not hundreds of row, but enough to
give us an idea what you are asking for. Also show us the calculation you
want to make or at least, based on the same what you want.

 

[Fred Smith]

Assume you have real dates in A1 to K1 (Jan to Dec)
In A2, enter 100
In B2, enter =if(mod(month(b1)-1,3)<>0,a2,a2+100)
Copy across to K2

If you don't have real dates as headers, but simply Text (Jan to Dec), you
can change "month(b1)" to "column(b1)"

Regards,
Fred.

 

[Jacob Skaria]

Do you mean something like the below..

Col A contain dates formatted to month and year. Jan-09 is in cell A3. In B3
enter the formula =IF(MOD(MONTH(A3),3)=1,B2+100,B2)

ColA ColB
Amount
Starting 1000
Jan-09 1100
Feb-09 1100
Mar-09 1100
Apr-09 1200
May-09 1200
Jun-09 1200
Jul-09 1300
Aug-09 1300
Sep-09 1300
Oct-09 1400
Nov-09 1400
Dec-09 1400
Jan-10 1500


If this post helps click Yes