Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Semi Annual Counter
I am try to calculate semi annual masks in a model. My model has a switch
which turns the model into 1 of 4 modes (Annual, SA, Quaterly, Monthly) - the first series. I want to be able to calculated the SA (Semi Annual) Period Counter in all four scenarios. So when the first counter changes, I want to semi annual counter to adjust as well.I know I have to use the MOD() function but I can't seem to integrate so that it works in all four scenarios. The idea being that is will use the series above it to generate the proper SA periods. Can anyone provide a tip on this The result should look like this below: Annual Scenario Annual Periods Couter 1 2 3 4 5 6 7 SA Periods Counter 2 2 2 2 2 2 2 SA Scenario SA Periods Counter 1 2 3 4 5 6 7 SA Periods Counter 1 2 1 2 1 2 1 Quarterly Scenario Quaterly Periods Counter1 2 3 4 5 6 7 SA Periods Counter 1 1 2 2 1 1 2 Monthly Scenario Monthly Periods Counter 1 2 3 4 5 6 7 SA Periods Counter 1 1 1 1 1 1 2 Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Semi Annual Counter
Reduced to a general case, the task is to convert the
series {1,2,3,....,12} into 1 2 1 2 1 2 1 2 1 2 1 2 1 1 2 2 1 1 2 2 1 1 2 2 1 1 1 1 1 1 2 2 2 2 2 2 given a key of 2, 4 or 12. For each row and its key, enter this array formula =CEILING((MOD(series-1,key)+1)/key*2,1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Future value plus annual contributions | Excel Worksheet Functions | |||
Arrays | Excel Discussion (Misc queries) | |||
Referencing a newly created worksheet | Excel Worksheet Functions | |||
Creating a counter that does not include hidden rows | Excel Discussion (Misc queries) | |||
Increment a counter in Excel | Excel Worksheet Functions |