I am looking for an alternative formula to get around the 7 nested IF limit. This is the formula that I am using: "=IF(ISNUMBER(SEARCH("WARE",F10)),G10-(30/60/24),IF(ISNUMBER(SEARCH("PALMER",F10)),G10-(30/60/24),IF(ISNUMBER(SEARCH("AMHERST",F10)),G10-(45/60/24),IF(ISNUMBER(SEARCH("BELCHERTOWN",F10)),G10-(30/60/24),IF(ISNUMBER(SEARCH("CHICOPEE",F10)),G10-(45/60/24),IF(ISNUMBER(SEARCH("EAST LONGMEADOW",F10)),G10-(60/60/24)))))))." As you can see it is looking for town names in a cell and performing a time calc based on the town. My issue is that I need to extend this formula to about 25 more towns. Any help would be greatly appreciated.
Bookmarks