Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enter Range
I have a list of data in Column B, and I need a formula in column A that
returns either dependant on what the cell value is in column B. Needs to return on of the following '<31', '31 - 60', 61 - 90', '91 - 180', '180' e.g Column A Coulmn B 31 - 60 45 180 189 31 - 60 52 91 - 180 118 etc Can this be done at all? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you enter input range for a histogram | Excel Discussion (Misc queries) | |||
How do you enter input range for a histogram | Excel Discussion (Misc queries) | |||
User must enter something in a range of cells | Excel Discussion (Misc queries) | |||
How do I enter formula that adds a range if less than a number or | Excel Worksheet Functions | |||
Trying to enter a range of numbers using >1 and < 5 in a formula | Excel Worksheet Functions |