| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Really need help with formula(Excel Office 2003)
In an excel spreadsheet as below: Cell A1 = 53.25. I need a formula in cell
B1 that would find where the 53.25 would fall within columns C and D with a result from column E. As in 53.25 falls between 46 and 55, so the resulting '3' would be the answer I need in cell B1. Is there such a formula? I'm sorry I'm not explaining this scenario well, but I would be forever grateful for any help. A B C D E 1 53.25 _____ 26 35 1 2 36 45 2 3 46 55 3 4 56 65 4 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening an Office 2003 Excel doc with Office 2000 NT | Excel Discussion (Misc queries) | |||
| Opening an Office 2007 Excel file in Office 2003 | Excel Discussion (Misc queries) | |||
| Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
| Unable to access the Office Online Web site in Office 2003, Excel | Excel Discussion (Misc queries) | |||
| Need to convert Office 97 Excel doc to Office 2003! | Excel Discussion (Misc queries) | |||
Threaded Mode
