+ Reply to Thread
Results 1 to 2 of 2

Multiply two cells if cell contains a specific word

  1. #1
    Registered User
    Join Date
    06-20-2011
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    18

    Exclamation Multiply two cells if cell contains a specific word

    I've been looking everywhere for a solution to this but I haven't found one yet.

    If cell contains a specific word, then multiply two cells. But if cell contains a different word then multiply two other cells. But if the cell is blank, leave blank.

    For example if Cell N4 = "Even" then multiply Cell M4 by Cell A1 and enter in Cell A4,. Or if Cell N4 = "Ramp" then multiply Cell M4 by Cell A2 and enter in Cell A4. But if Cell N4 is blank, leave Cell A4 blank.

    Then I will drag the formula so it applies to all cells from A4 to cell L4.

    I have attached the excel spreadsheet.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Multiply two cells if cell contains a specific word

    Put this formula in A4:

    =IF($N4="","",$M4*IF($N4="Even",A$1,A$2))

    then copy across and down as required.

    Hope this helps.

    Pete

+ 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. [SOLVED] Multiply Value from the drop down to a specific cell
    By pphg in forum Excel General
    Replies: 6
    Last Post: 04-26-2017, 06:11 AM
  2. [SOLVED] remove specific text from certain cells, then multiply the numerical value left by 0.001
    By jeffnoone in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-21-2014, 02:25 PM
  3. Replies: 10
    Last Post: 07-18-2013, 04:33 PM
  4. Replies: 7
    Last Post: 07-16-2013, 06:47 AM
  5. [SOLVED] Copy specific cells based on one word in the cell, to a different worksheet
    By Lfaulst1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-30-2013, 05:26 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