+ Reply to Thread
Results 1 to 4 of 4

Multiply ... times so it's atleast ...

  1. #1
    Registered User
    Join Date
    03-07-2015
    Location
    Rotterdam
    MS-Off Ver
    2013
    Posts
    5

    Multiply ... times so it's atleast ...

    Dear Excel-forum members,

    I've the following problem: I want a specefic number to be multiplied by at least ... times so that the value is min. 50 (see Excel document).
    Any help would be great!!
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Multiply ... times so it's atleast ...

    =CEILING(B1/B2,1)
    Try this
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Multiply ... times so it's atleast ...

    Here is another possible answer.

    =ROUNDUP(B1/B2,0)
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    03-07-2015
    Location
    Rotterdam
    MS-Off Ver
    2013
    Posts
    5

    Re: Multiply ... times so it's atleast ...

    Thanks!
    Now that I know how to do that, I've got a new document with a question inside.

    It may look confusing but the 3 red cells are the important one's which are missing a formula.
    Attached Files Attached Files

+ 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 times with numbers
    By Khaldon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-17-2015, 05:06 PM
  2. [SOLVED] Macro to copy row and multiply by n times
    By mlocy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2013, 10:55 AM
  3. [VBA] Multiply each cell of a column 5 times
    By Eldexoly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2011, 12:26 PM
  4. how can I multiply a 45-vector times a 45*45 matrix?
    By jortorzor in forum Excel General
    Replies: 2
    Last Post: 03-24-2005, 11:06 AM
  5. Multiply One Column Times Another Summed by Row
    By Mkren911 in forum Excel General
    Replies: 1
    Last Post: 03-03-2005, 08:24 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