Results 1 to 7 of 7

Generating number multiples

Threaded View

  1. 11-08-2016, 01:53 PM #1
    mxdzieg
    mxdzieg is offline
    Registered User
    Join Date
    09-20-2013
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    6

    Generating number multiples

    Hi guys,

    I'm looking for a formula to generate multiples of a number. So let's say you have the following #s in columns A & B:
    A B C
    184912000 6
    184845000 6
    184617000 3
    184562000 8
    184453000 3


    In column C I'd like to see 184912000 six times, then 184845000 six times, then 184617000 three times, etc.

    What's a good formula to make that happen?
    Last edited by mxdzieg; 11-08-2016 at 01:56 PM.
    Reply With QuoteRegister To Reply
« 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] Conditional Formatting For Cells with Multiples of a Certain Number
    By JAMES456 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2015, 12:59 PM
  2. Conditional Format multiples of a number
    By JakeMann in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-13-2013, 09:25 AM
  3. Formula to look for multiples of a number in a range
    By Beantown in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-08-2013, 10:11 AM
  4. [SOLVED] increasing a cells number by multiples
    By Earthfury in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-09-2012, 02:50 AM
  5. [SOLVED] Formula for dividing and rounding a number with multiples of 500
    By mojitomaster in forum Excel General
    Replies: 5
    Last Post: 05-14-2012, 07:11 AM
  6. Generate random number in multiples of 100
    By maacmaac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-01-2009, 11:22 PM
  7. [SOLVED] How do I break down a number by multiples in Excel?
    By brian_sampson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-14-2006, 03:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1