Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel less than greater than 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 | |||
Formula greater than | Excel Worksheet Functions | |||
Greater than but less than formula | Excel Worksheet Functions | |||
Formula in Excel to show greater than 50, but less than 250? | Excel Worksheet Functions | |||
FORMULA FOR if(GREATER THAN, BUT LESS THAN,THIS,OR THAT | Excel Worksheet Functions | |||
formula for Greater of C or D X E | Excel Discussion (Misc queries) |