Tech Support Forum - View Single Post - Excel formula to match a number from a selection of data (OR and IF function)

Dark Poison · 06-23-2009, 06:29 AM

Hi there, i'm having difficulty trying to make this forumla behave itself. Basically i want a set price to be given to each station if it falls under that particular price category. The formula is as follows;

=IF(OR(I4="Hatfield", I4="Huntingdon", I4="Letchworth"),90,(IF(OR(I4="Bedford", I4="Flitwick", I4="Stevenage"),125,(IF(OR(I4="Downham Market", I4="Kings Lynn"),70,(IF(OR(I4="Luton", I4="LAP", I4="Luton Airport Parkway", I4="St Albans", I4="St Albans & Harpenden"),140),(IF(I4="Hitchin",100))))))))

now when i fill series this down my list, it works for all stations exept for Hitchin, Luton, Luton airport Parkway, St Albans & Harpenden, Letchworth and St Albans. Why is that?

I4 is the cell and column with the name of each station, of course.

06-23-2009, 06:29 AM	#1 (permalink)
Dark Poison Registered User Join Date: Dec 2007 Posts: 13 OS: Win XP Home	Excel formula to match a number from a selection of data (OR and IF function) Hi there, i'm having difficulty trying to make this forumla behave itself. Basically i want a set price to be given to each station if it falls under that particular price category. The formula is as follows; =IF(OR(I4="Hatfield", I4="Huntingdon", I4="Letchworth"),90,(IF(OR(I4="Bedford", I4="Flitwick", I4="Stevenage"),125,(IF(OR(I4="Downham Market", I4="Kings Lynn"),70,(IF(OR(I4="Luton", I4="LAP", I4="Luton Airport Parkway", I4="St Albans", I4="St Albans & Harpenden"),140),(IF(I4="Hitchin",100)))))))) now when i fill series this down my list, it works for all stations exept for Hitchin, Luton, Luton airport Parkway, St Albans & Harpenden, Letchworth and St Albans. Why is that? I4 is the cell and column with the name of each station, of course.