+ Reply to Thread
Results 1 to 3 of 3

Multiply if

  1. 05-08-2022, 09:38 AM #1
    Scolk
    Scolk is offline
    Registered User
    Join Date
    07-24-2013
    Location
    canada
    MS-Off Ver
    Excel 2011 mac
    Posts
    8

    Multiply if

    I need help with something that seemed simple, but I could not find a way to do it. In D30 I want to multiple D9 by 125 if D9 is smaller or equal to 6 or multiply by 150 if D9 is greater than 7.

    Thanks
    Reply With QuoteRegister To Reply
  2. 05-08-2022, 09:43 AM #2
    JohnTopley
    JohnTopley is offline
    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,245

    Re: Multiply if

    Try

    =IF(D9<=6,D9*125,D9*150)

    D9 is greater than OR EQUAL 7
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 05-08-2022, 10:22 AM #3
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,097

    Re: Multiply if

    Another option
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help with VBA multiply
    By rosscortb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2018, 11:11 AM
  2. [SOLVED] Need to multiply a VLOOKUP value then divide that value, then multiply that value
    By debbiemez in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-27-2015, 04:57 PM
  3. multiply
    By mertserveren in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2014, 08:48 AM
  4. [SOLVED] If result of calculation is greater than x then multiply by y if less the multiply by z
    By Btosh4 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2014, 09:32 AM
  5. 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
  6. [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
  7. add and then multiply
    By ihsaan in forum Excel General
    Replies: 3
    Last Post: 02-04-2010, 05:23 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1