+ Reply to Thread
Results 1 to 2 of 2

Xl2010 - multiple 'if' formula needed for one cell

  1. #1
    Registered User
    Join Date
    03-20-2019
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    10

    Question Xl2010 - multiple 'if' formula needed for one cell

    So I have a table whereby if a cell contains a certain number it will perform a specific calculation based on this certain number.

    In this case (attached), if B2 contains an 11 I need C2 to perform A2/1.5. And if it contains a 10 I need C2 to perform A2/1.45. Any other number should cause C2 to remain blank. Ideally I need this calculation in the same formula.

    Is this possible?
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Xl2010 - multiple 'if' formula needed for one cell

    .
    Paste in C2 and drag down column :
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. date formula help needed with blank cell and monthly assumtions formula needed
    By Michael.Howarth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2018, 07:47 AM
  2. [SOLVED] Multiple “IF” formula needed
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2016, 08:14 PM
  3. XL2010 formula copying bug?
    By Oppressed1 in forum Excel General
    Replies: 18
    Last Post: 06-25-2015, 06:08 PM
  4. Assistance for XL2010 simple IF formula
    By sambo24 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 03-21-2014, 07:11 PM
  5. [SOLVED] Formula Needed to fill in color on multiple cells when a word is entered into another cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2013, 05:42 PM
  6. Unable to use cell lock feature - XL2010
    By Beth Hoffmann in forum Excel General
    Replies: 2
    Last Post: 06-28-2013, 03:04 PM
  7. Tricky formula needed to format multiple columns into one cell
    By joejnknsn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2012, 06:00 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