+ Reply to Thread
Results 1 to 2 of 2

Muliply if A if met scenario 1, multiply B if met scenario 2

Hybrid View

  1. #1
    Registered User
    Join Date
    08-11-2020
    Location
    Catbalogan City, Samar, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    12

    Muliply if A if met scenario 1, multiply B if met scenario 2

    Hello Everyone,

    Please help. I have this problem in excel. I want to Multiply cell H6 to cell E6 if met a certain quantity. And Multiply cell H6 to D6 if met another certain quantity. I just don't know what formula to use.

    Thank you very much!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,198

    Re: Muliply if A if met scenario 1, multiply B if met scenario 2

    It depends on how dynamic you want to make it, but to simply answer your question,
    In cell I6 you can try this:
    =IF(H$3=0.8,H6*E6,H6*D6)
    and in cell I16, try this:
    =IF(H$13=0.8,H16*E16,H16*D16)

+ 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. Automatically Run Macro Once a Different Scenario is Chosen in Scenario Manager
    By because789 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2020, 03:42 PM
  2. Making a Scenario Pivot Table in Scenario Manager Issue
    By davandbar in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-22-2018, 03:33 PM
  3. What-If Scenario
    By ORWS in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-24-2017, 08:40 AM
  4. Scenario Manager displays same result for every scenario
    By terihoff in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 11-10-2012, 07:14 PM
  5. Replies: 0
    Last Post: 08-16-2012, 01:32 PM
  6. Not able to Add a Scenario
    By Harshit Kohli in forum Excel General
    Replies: 0
    Last Post: 08-15-2012, 02:43 PM
  7. IF Scenario
    By will.00 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 07: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