Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I am trying to create a formula
I am trying to create a formula for the following information:
0 < 2, 11.33 per month 2 < 5, 14.66 per month 5 < 10, 16.66 per month 10 < 20, 18 per month 20, 20 per month This is for the following table: K L M N O P DOH Date Tenure Years Accural Rate Total 5 03/21/03 1/31/08 1777 4 0.00 6 03/21/03 2/29/08 1806 4 0.00 7 03/21/03 3/31/08 1837 5 0.00 8 03/21/03 4/30/08 1867 5 0.00 9 03/21/03 5/31/08 1898 5 0.00 10 03/21/03 6/30/08 1928 5 0.00 11 03/21/03 7/31/08 1959 5 0.00 12 03/21/03 8/31/08 1990 5 0.00 13 03/21/03 9/30/08 2020 5 0.00 14 03/21/03 10/31/08 2051 5 0.00 15 03/21/03 11/30/08 2081 5 0.00 16 03/21/03 12/31/08 2112 5 0.00 I need it to calculate the responce in O |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a formula by joining text and the value from a formula | Excel Worksheet Functions | |||
Create formula | Excel Discussion (Misc queries) | |||
How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
How do I create a formula | Excel Programming |