- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Excel formula question
Posted on 12/19/12 at 5:53 pm to Motorboat
Posted on 12/19/12 at 5:53 pm to Motorboat
quote:
=IF(B2="97001",185,IF(B2="97110",48,IF(B2="97104",32,IF(B2="97010",25,IF(B2="97140",59""))))
As the others said, having a lookup table is best.
But if you have to do it this way instead, your formula shouldn't have all the numbers quoted like that unless cell B2 truly is a text value.
For example, if you enter the number 97110 in cell B2 your formula will not match anything. If you enter the string '97110 then it will return the number 48.
After you put a comma between the 59 and the two consecutive double quotes, that is.
Popular
Back to top
Follow TigerDroppings for LSU Football News