Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula increment in2ition Excel Worksheet Functions 4 June 24th 08 01:30 AM
increment Address formula Gizmo Excel Discussion (Misc queries) 5 March 31st 08 05:00 AM
Am trying to autofill a formula and it will not increment down? Opsmgr Excel Worksheet Functions 1 January 30th 08 08:58 PM
MONTH INCREMENT FORMULA deepak bsg[_2_] Excel Discussion (Misc queries) 3 August 23rd 07 08:56 AM
How do I increment a formula? JICDB Excel Worksheet Functions 2 September 16th 05 06:53 PM


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"