+ Reply to Thread
Results 1 to 4 of 4

Multiply and then round numbers

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    145

    Multiply and then round numbers

    Hi all,
    I need a macro (only macro, not a formula) that will multiply numbers by 1.35 and ONLY AFTER THAT will round them, subject to their value, according to the following model:

    0 to 99 - multiply by 1.35 and round to the nearest 10
    100 to 999 - multiply by 1.35 and round to the nearest 50
    1,000 to 9,999 - multiply by 1.35 and round to the nearest 100
    10,000 to 99,999 - multiply by 1.35 and round to the nearest 1,000
    100,000 to 999,999 - multiply by 1.35 and round to the nearest 10,000
    1,000,000 or more - multiply by 1.35 and round to the nearest 100,000

    Please see the file attached, on column A you can see a few sample numbers, on column C you can see the desired results.

    Any help will be highly appreciated,
    Sami
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    145

    Re: Multiply and then round numbers

    Any idea how to solve it?..

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Multiply and then round numbers

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    145

    Re: Multiply and then round numbers

    Thanks a lot!
    Sami
    Quote Originally Posted by stnkynts View Post
    Please Login or Register  to view this content.

+ 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. Multiply by percentage and round final results
    By jeffreybrown in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-04-2012, 05:51 PM
  2. Multiply range with constant and round results
    By ciprian in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2011, 04:58 AM
  3. Excel 2007 : Multiply and round in same cell
    By OCT02 in forum Excel General
    Replies: 2
    Last Post: 11-16-2010, 11:41 AM
  4. multiply and round in one equation
    By rdaled in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-01-2007, 03:21 PM
  5. [SOLVED] Multiply one cell by a factor and make that result round
    By Machel_C in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-15-2005, 04:06 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