+ Reply to Thread
Results 1 to 5 of 5

VBA to round off amount in coloumn C

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    643

    VBA to round off amount in coloumn C

    Hi,

    I thought it would be simple code. I have column C with amount such as

    C1 : 3712.76
    C2 : 277.91

    I am looking for a VBA code which can do this..

    Thanks

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: VBA to round off amount in coloumn C

    There is no round off, only round, roundup or rounddown. Assuming you want round, here is a typical macro:

    Please Login or Register  to view this content.
    Gary's Student

  3. #3
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    643

    Re: VBA to round off amount in coloumn C

    Hi,

    Thanks for your code. It works but it ends up creating a value to 3713.00. Instead I want value to be only 3713. I do not want visible zero's at the end.
    Could you please assist me getting your code modified to it.

    Thanks

  4. #4
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    643

    Re: VBA to round off amount in coloumn C

    with some error n trial. I was able to work it out
    Thanks Jakobshavn for your code.

  5. #5
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: VBA to round off amount in coloumn C

    Thanks for the feedback!

+ 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] Round Amount
    By yukioh in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-19-2013, 03:38 AM
  2. [SOLVED] Round formula including multiply by zero produces rounded amount
    By Thisyearsman in forum Excel General
    Replies: 2
    Last Post: 05-09-2012, 12:25 PM
  3. [SOLVED] To round off the percetage amount into 1
    By PRADEEPB270 in forum Excel General
    Replies: 1
    Last Post: 08-23-2010, 03:11 AM
  4. Round amount to nearest $10 after other formula calc. in same cell
    By debtors in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2006, 07:50 AM
  5. 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