+ 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
    7

    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
    5,125

    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)

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