+ Reply to Thread
Results 1 to 4 of 4

Multiply depending on if letter is in cell

  1. #1
    Registered User
    Join Date
    08-24-2015
    Location
    America
    MS-Off Ver
    2010
    Posts
    7

    Multiply depending on if letter is in cell

    I want to multiply B1*140 if A1 has the letter A in it, or B1*170 if A1 has the letter B in it, or B1*200 if A1 has the letter C in it. For example A1 might have "C4" so B1 should be multiplied by 200. So what is a formula that will disregard the number in A1 and only search for "A", "B", or "C" while multiplying B1 with the right number? Thanks for being nice by reading my post!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Multiply depending on if letter is in cell

    Here, try this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,197

    Re: Multiply depending on if letter is in cell

    Try ..

    =B1 * LOOKUP(LEFT(A1,1),{"A","B","C"},{140,170,200})

    Note that Zbor's formula is case-sensitive
    Last edited by JohnTopley; 09-05-2015 at 10:16 AM.

  4. #4
    Registered User
    Join Date
    08-24-2015
    Location
    America
    MS-Off Ver
    2010
    Posts
    7

    Re: Multiply depending on if letter is in cell

    It works, thanks for the help John!

+ 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. Replies: 25
    Last Post: 04-21-2015, 10:19 AM
  2. [SOLVED] Match letter of ranges depending value entered
    By cgkmal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2014, 07:50 PM
  3. If criteria match, multiply then sum across multiply worksheets
    By ciayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 02:20 PM
  4. [SOLVED] Multiply, Divide and Then Multiply in a cell
    By Brownie2576 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-22-2012, 08:57 PM
  5. [SOLVED] Multiply results of cell depending on number in cell
    By sparky24 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-21-2012, 02:13 PM
  6. Multiply Depending on year
    By ZackG in forum Excel General
    Replies: 2
    Last Post: 05-02-2011, 11:45 AM
  7. Replies: 2
    Last Post: 07-26-2005, 03:05 AM

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