+ Reply to Thread
Results 1 to 5 of 5

Multiple Product IF Function

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    here
    MS-Off Ver
    7
    Posts
    2

    Multiple Product IF Function

    I am trying to find a function where if I have PERSON X in a cell I want to multiply a number from a different cell by designated number, but if it is PERSON Y then I want to multiply by a different number. I have this so far and it works for ONE person. How do I add another user?

    =PRODUCT(IF(D2="PERSON X",W2*85,""))

    Any feedback would be greatly appreciated. Thanks.

  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: Multiple Product IF Function

    Do you have those names and associated numbers listed somewhere in a little table? If so, you could use VLOOKUP to get the appropriate value for the name. Post an example workbook (the FAQ describes how to) if you want further details.

    Hope this helps.

    Pete

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Multiple Product IF Function

    No idea how it works, but:


    =PRODUCT(IF(D2="PERSON X",W2*85,IF(D2="PERSON Y",W2*secondnumber,""),""))
    Quang PT

  4. #4
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Multiple Product IF Function

    Hello
    No need to use product when you are simply multiplting....
    You can use this one..
    =IF(D2="PERSON X",W2*85,IF(D2="Person Y","YOUR FORMULA",""))

    Tell me if it works right….

    Hope it helps

    If you are satisfied then mark the thread as solved and you can just click on ADD REPUTATION below my post to say thanks...by doing this you add to my reputation…...

    Regards
    Sourabh Gupta

  5. #5
    Registered User
    Join Date
    01-26-2015
    Location
    here
    MS-Off Ver
    7
    Posts
    2

    Re: Multiple Product IF Function

    That worked perfectly. Thank you sourabhg98 for the help

+ 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. Macro to sum the product of multiple cells across multiple worksheets
    By ciayers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2013, 03:28 PM
  2. [SOLVED] Need Function that will find ordered product, and display the product code in a 2nd workbk
    By rollerden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2012, 08:52 AM
  3. Replies: 2
    Last Post: 04-02-2009, 05:56 AM
  4. Sum of Product Multiple Columns/Multiple Sheets, Indefinite Range
    By endurion in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2007, 05:33 PM
  5. Product Function in Pivot Tables from Multiple Consolidation Range
    By bbishop222 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2005, 01:06 PM

Tags for this Thread

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