| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Failing with formula
Hi,
I need to create a formula the will give the following results: IF B8 is between 1 and 5000 the result is 1, if B8 is between 5001 and 10000 the result is 2 and so on. Any help would be appreciated. Many thanks Charlie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Failing IF Statement | Excel Discussion (Misc queries) | |||
| Data query failing | Excel Worksheet Functions | |||
| COUNTA failing? | Excel Discussion (Misc queries) | |||
| My formulas are failing! | Excel Discussion (Misc queries) | |||
| Link 'failing' | Links and Linking in Excel | |||
Threaded Mode
