+ Reply to Thread
Results 1 to 3 of 3

Times and numbers multiplication with minimum value

  1. #1
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Post Times and numbers multiplication with minimum value

    Hi,

    I would like please a formula to calculate the payment of 150 for each hour in the attached cell C12, with a minimum payment of 450.

    In the attached sheet example, I expect the formula to return 882.
    5.88 X 150 = 882
    882 is higher than the minimum 450,
    So, the final result should be 882 instead of the 21168 the present formula result I tried and did not work in E12.
    Last edited by Khaldon; 03-23-2021 at 10:46 AM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Times and numbers multiplication with minimum value

    The formula in E12 is multiplying 5.88 by 150 then by 24. Your description says that you want it to multiply 5.88 by 150. Is the *24 in the formula a mistake? Would simply removing *24 resolve the question?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Re: Times and numbers multiplication with minimum value

    Yes the *24 in the formula was a mistake, removing the *24 did resolve my question.
    Thank you,

+ 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: 5
    Last Post: 04-15-2020, 01:31 AM
  2. Multiplication of several numbers in one cell
    By dinahajjar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-07-2014, 05:00 AM
  3. setting a minimum value to a multiplication
    By idanwcd in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2014, 05:24 PM
  4. [SOLVED] Multiplication & divide with a minimum & maximum return
    By allend5 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2013, 08:29 AM
  5. Minimum time between two times
    By Bishonen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2013, 09:08 AM
  6. Matrix multiplication with complex numbers
    By zafor99 in forum Excel General
    Replies: 0
    Last Post: 12-14-2007, 05:38 AM
  7. sorting multiple minimum times
    By the swimmer in forum Excel General
    Replies: 2
    Last Post: 12-22-2005, 10:35 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