+ Reply to Thread
Results 1 to 3 of 3

rounding down to nearest 3 decimal places after the decimal point

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    rounding down to nearest 3 decimal places after the decimal point

    hi guys

    i have the following in cell S11
    Please Login or Register  to view this content.
    T6 is a whole number always lets say 3 in this example
    cells u4 or u5 may not be whole numbers
    for example if cell U4 is 0.90166666667 and U5 is 1.500

    then i get the answer
    3 units @ 0.90166666667 x 1.500

    so what i really need it to read is
    3 units @ 0.901 x 1.500

    thanks in advance

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: rounding down to nearest 3 decimal places after the decimal point

    =T6 & " Units @ " & TEXT(ROUNDDOWN(U4, 3), "0.000") & " x " & TEXT(ROUNDDOWN(U5, 3), "0.000")
    Last edited by shg; 10-18-2018 at 11:41 AM. Reason: forgot the rounddown
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    02-18-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    356

    Re: rounding down to nearest 3 decimal places after the decimal point

    Thanks SHG

+ 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] Get 5 Decimal places without rounding off
    By puuts in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-10-2013, 09:38 AM
  2. [SOLVED] Rounding Decimal Places in Increments
    By adam2308 in forum Excel General
    Replies: 2
    Last Post: 02-11-2013, 07:56 PM
  3. [SOLVED] Problem with rounding up decimal places.
    By jamietttt in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-15-2013, 02:57 PM
  4. 2 Decimal Places without rounding ?
    By _Lewis in forum Excel General
    Replies: 8
    Last Post: 04-08-2011, 06:14 AM
  5. Replies: 4
    Last Post: 06-10-2009, 12:50 PM
  6. decimal places and rounding up
    By byepeeps in forum Excel General
    Replies: 7
    Last Post: 02-09-2007, 10:48 AM
  7. [SOLVED] FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT.
    By SUKYKITTY in forum Excel General
    Replies: 3
    Last Post: 07-06-2005, 09:05 AM
  8. [SOLVED] Decimal places and rounding up (or down)
    By Ash in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-15-2005, 06:45 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