Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with Excel formula
How do I create a formula that will return a number 1-10 depending on data
entered ranging from 1-57. Example. I have 10 fire districts. Each district has about 5 Fire Stations in no particular order. If I put in fire station number 10 then the fire district 2 will auto fill-in. Here is my formula that i am trying to build but it's limited to a certain number I think 8. =IF(H26=3,1,IF(H26=4,1,IF(H26=6,1,IF(H26=18,1,IF(H 26=24,1,IF(H26=7,2,IF(H26=10,2,IF(H26=20,2,0)))))) )) Can I group numbers together in the formula such as Fire Stations 3, 4, 6, 18, or 24 = 1 7, 10, 13, 20 or 56 =2 8, 11, 17, 19 or 44 = 3 ...... = 4 ...... = 5 ...... = 6 ...... = 7 ...... = 8 ...... = 9 ...... = 10 Thanks very much! -- Firefighter Instructor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |