Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula to find increment ?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula to find increment ?
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "chandra1961" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula to find increment ?
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. "chandra1961" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula to find increment ?
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 --------------- Jacob Skaria "chandra1961" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula increment | Excel Worksheet Functions | |||
increment Address formula | Excel Discussion (Misc queries) | |||
Am trying to autofill a formula and it will not increment down? | Excel Worksheet Functions | |||
MONTH INCREMENT FORMULA | Excel Discussion (Misc queries) | |||
How do I increment a formula? | Excel Worksheet Functions |