Results 1 to 7 of 7

Help with IF and OR Formula

Threaded View

XcelRookie Help with IF and OR Formula 04-03-2021, 08:01 PM
6StringJazzer Re: Help with IF and OR... 04-03-2021, 08:34 PM
XcelRookie Re: Help with IF and OR... 04-03-2021, 09:33 PM
Estevaoba Re: Help with IF and OR... 04-03-2021, 08:36 PM
XcelRookie Re: Help with IF and OR... 04-04-2021, 07:07 PM
6StringJazzer Re: Help with IF and OR... 04-03-2021, 10:05 PM
Estevaoba Re: Help with IF and OR... 04-04-2021, 07:10 PM
  1. #1
    Registered User
    Join Date
    02-03-2012
    Location
    Merrimack Valley, MA
    MS-Off Ver
    Excel 2007
    Posts
    5

    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
    Attached Files Attached Files
    Last edited by XcelRookie; 04-03-2021 at 08:36 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1