+ Reply to Thread
Results 1 to 6 of 6

Rounddown or Round or what?

  1. 08-19-2015, 05:10 AM #1
    David HK
    David HK is offline
    Registered User
    Join Date
    02-05-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    56

    Rounddown or Round or what?

    The attached file shows part of my water bill.

    The figures in D 12 and D 13 should actually be the true figures shown in G 12 and G 13.

    How can I achieve this?

    Any assistance would be much appreciated.

    Dave
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-19-2015, 05:28 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Rounddown or Round or what?

    How are you arriving on those figures? Seems as if you will need rounddown..
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 08-19-2015, 05:31 AM #3
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Rounddown or Round or what?

    It's B12*C12 and B13*C13.
    The figures are rounded up because you have 3 decimal places in column B.
    Use ROUNDDOWN(D12,2)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  4. 08-19-2015, 05:36 AM #4
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Rounddown or Round or what?

    A
    B
    C
    D
    E
    F
    G
    H
    Cubic metres
    Rate per
    Cost
    ***
    Should read
    Balance b/f
    $0.05
    12.529
    $0.00
    $0.00
    32.366
    $4.16
    $134.64
    =B11*C11
    =ROUNDDOWN(E11,2)
    19.837
    $6.45
    $127.95
    =B12*C12
    $127.94
    =ROUNDDOWN(E12,2)
    12.268
    $9.05
    $111.03
    =B13*C13
    $111.02
    =ROUNDDOWN(E13,2)
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  5. 08-19-2015, 06:01 AM #5
    David HK
    David HK is offline
    Registered User
    Join Date
    02-05-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Rounddown or Round or what?

    Yes, your suggestions are noted, but I want the true answer in the D column.

    In other words the value in Column B times the value in Column C should give the required answer in Column D.

    This is where I am 'stuck' so to speak.

    I do not wish to use helper Columns.

    If I have misunderstood your answers please let me know.

    Dave
    Reply With QuoteRegister To Reply
  6. 08-19-2015, 06:01 AM #6
    David HK
    David HK is offline
    Registered User
    Join Date
    02-05-2013
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Rounddown or Round or what?

    Yes, your suggestions are noted, but I want the true answer in the D column.

    In other words the value in Column B times the value in Column C should give the required answer in Column D.

    This is where I am 'stuck' so to speak.

    I do not wish to use helper Columns.

    If I have misunderstood your answers please let me know.

    Dave
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Using round formulas to always select a total round number of 10?
    By nobodyukno in forum Excel General
    Replies: 2
    Last Post: 12-06-2014, 01:58 PM
  2. [SOLVED] How to round to nearest .01 and round down if thousands place is .005
    By dredre609 in forum Excel General
    Replies: 5
    Last Post: 09-29-2014, 11:47 AM
  3. [SOLVED] Round, Roundup, Rounddown or something else????
    By PERE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2013, 09:14 AM
  4. [SOLVED] Rounddown
    By Lsinshirley in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2011, 04:15 PM
  5. Trying to multiply two =ROUNDDOWN(C4/Sheet2!B3,0), =ROUNDDOWN(D4/Sheet2!C3,0)?
    By 2low4snow in forum Excel General
    Replies: 1
    Last Post: 02-09-2010, 05:40 AM
  6. rounddown
    By jnf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-17-2006, 09:20 AM
  7. [SOLVED] How do I ROUND() round off decimals of a column dataset?
    By Højrup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 07:06 AM

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