Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to classify numbers ?
Hi,
Lets consider the folowing table: A B C D E 1 Invoice Date Amount Days Old Group 2 B21 21.5.09 200 60 C 3 yyy 30 B 15 A 120 D 360 E 450 245 Group defination: 0 < A < 20 20 < B < 35 35 < C < 65 65 < D <135 135 < E The group classification is a range where the number of days lies. May I know the formula for cell E2 that enable me to get the answers when copy downwards ? Thanks Low -- A36B58K641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : How to remove large page numbers ? | Excel Discussion (Misc queries) | |||
Excel 2002: How to add running numbers ? | Excel Discussion (Misc queries) | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
How do you classify an Excel user? | Excel Discussion (Misc queries) | |||
Excel 2002 - Filtering numbers | Excel Discussion (Misc queries) |