Results 1 to 9 of 9

Product and Round a series of numbers

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Product and Round a series of numbers

    Hi All,

    I have to do this kind of calculation quite often and i would like to know if there is a shortcut out there somewhere. The scenario is that i would like to multiply 2 numbers together then round to the nearest penny, then multiply that value by another number and round to the nearest penny, and continue this pattern on for a set amount of numbers. Mind you the end value will sometimes be different than just multiplying all of the numbers together then rounding at the end. Here is an example:

    Column A
    1.19
    1.11
    1.86
    1.47
    1.36
    1.09
    1.78
    1.02
    1.20

    If you were to do this formula round(product(A2:A10),2) you would come up with 11.66, but i would like the value that is calculated from this formula:
    =ROUND(ROUND(ROUND(ROUND(ROUND(ROUND(ROUND(ROUND(A2*A3,2)*A4,2)*A5,2)*A6,2)*A7,2)*A8,2)*A9,2)*A10,2) which would be 11.68

    This number can be significatly different if the numbers that you are looking at have more than two decimal places. I am looking for a formula, if at all possible, that will do what i have shown just must shorter. Thanks in advance for any assistance.
    Last edited by amotto11; 08-20-2013 at 02:23 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Random Series of Numbers - Each series to have same GEOMEAN
    By nbezza in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-11-2013, 12:51 AM
  2. Using Product to convert Text(Numbers) to Numbers
    By flebber in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2010, 10:30 AM
  3. Xl 2007 VBA applying round dot format to chart series
    By Richard Buttrey in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-14-2009, 12:21 PM
  4. How do you round off numbers 5,518,943 to 5,520,000
    By laurn in forum Excel General
    Replies: 1
    Last Post: 08-16-2006, 10:35 AM
  5. Replies: 3
    Last Post: 04-20-2005, 05:06 PM

Tags for this Thread

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