| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trying to create a worksheet....
that can add a certain $ amount within a set time frame. For example... I
need to reach $15,000 within a consecutive 12 month period. But the 12 months is usually rolling. Any help or advice in the right direction would be GREATLY appreciated!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
trying to create a worksheet....
Try to describe the problem in more detail. And do it in the white space not
the Subject box best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Pasrxu" wrote in message ... that can add a certain $ amount within a set time frame. For example... I need to reach $15,000 within a consecutive 12 month period. But the 12 months is usually rolling. Any help or advice in the right direction would be GREATLY appreciated!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
trying to create a worksheet....
thanks for the advice .. how's this?
a person has to met a $15 k deductible within a consecutive 12 month period, but they have a 5 year period to do this, so they send in 5 years worth of paper work that needs to be added up. I am trying to create a worksheet that will notify me that $15 k has been reached within a rolling 12 month period. I have already created worksheets for a set timeframe but not a rolling one. Is this possible to create? thank you "Bernard Liengme" wrote: Try to describe the problem in more detail. And do it in the white space not the Subject box best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Pasrxu" wrote in message ... that can add a certain $ amount within a set time frame. For example... I need to reach $15,000 within a consecutive 12 month period. But the 12 months is usually rolling. Any help or advice in the right direction would be GREATLY appreciated!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
trying to create a worksheet....
In A1:A60 I have 60 dates (one for each month of the 5-year period).
Actually this is not used but is there for reference. In B1:B100 I have dollar amount for each month In C1 I have =SUM(B1:B12): this is copied down to C60 In D1 I have =IF(C1=15000,"OK",""); this is copied down to D60 If the 15k is meet within 12 consecutive months, a cell in column D shows OK If you have no data for certain months just leave blank rows before copying the C1 and D1 formulas Any help? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Pasrxu" wrote in message ... thanks for the advice .. how's this? a person has to met a $15 k deductible within a consecutive 12 month period, but they have a 5 year period to do this, so they send in 5 years worth of paper work that needs to be added up. I am trying to create a worksheet that will notify me that $15 k has been reached within a rolling 12 month period. I have already created worksheets for a set timeframe but not a rolling one. Is this possible to create? thank you "Bernard Liengme" wrote: Try to describe the problem in more detail. And do it in the white space not the Subject box best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Pasrxu" wrote in message ... that can add a certain $ amount within a set time frame. For example... I need to reach $15,000 within a consecutive 12 month period. But the 12 months is usually rolling. Any help or advice in the right direction would be GREATLY appreciated!!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
trying to create a worksheet....
thank you I will give this a try!!
"Bernard Liengme" wrote: In A1:A60 I have 60 dates (one for each month of the 5-year period). Actually this is not used but is there for reference. In B1:B100 I have dollar amount for each month In C1 I have =SUM(B1:B12): this is copied down to C60 In D1 I have =IF(C1=15000,"OK",""); this is copied down to D60 If the 15k is meet within 12 consecutive months, a cell in column D shows OK If you have no data for certain months just leave blank rows before copying the C1 and D1 formulas Any help? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Pasrxu" wrote in message ... thanks for the advice .. how's this? a person has to met a $15 k deductible within a consecutive 12 month period, but they have a 5 year period to do this, so they send in 5 years worth of paper work that needs to be added up. I am trying to create a worksheet that will notify me that $15 k has been reached within a rolling 12 month period. I have already created worksheets for a set timeframe but not a rolling one. Is this possible to create? thank you "Bernard Liengme" wrote: Try to describe the problem in more detail. And do it in the white space not the Subject box best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Pasrxu" wrote in message ... that can add a certain $ amount within a set time frame. For example... I need to reach $15,000 within a consecutive 12 month period. But the 12 months is usually rolling. Any help or advice in the right direction would be GREATLY appreciated!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
| Can I create a worksheet menu to select each other worksheet | Excel Discussion (Misc queries) | |||
| How do I create a worksheet within a worksheet in Excel? | Excel Worksheet Functions | |||
| how to create a "sub worksheet" | Excel Discussion (Misc queries) | |||
| Using VBA to create a new worksheet, and then target new worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
