Help with IF and OR Formula

I'm trying to simplify a spreadsheet and can't get it to work.

If the cell contains "Apple" or "Lemon" enter 650 or if cell contains "Banana" enter 1300 or if cell contains "Orange" enter 350 or if cell contains "Cherry" enter 150, else enter 0. Right now it's done manually.

Any help appreciated.

K

The best way to do this is with a lookup table. Put a table like this into a sheet called Lookup:

Apple	650
Lemon	650
Banana	1300
Orange	350
Cherry	150

then the formula is

Formula:

Please Login or Register  to view this content.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.