+ Reply to Thread
Results 1 to 5 of 5

Round up decimal value to one in VBA code

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Round up decimal value to one in VBA code

    i want some change in that VBA code which is in attached file i want that where is decimal value is
    equal or greater than 0.50 then round up that value to one.for example in the attached file you can see in cell A18 value is 48184.50 so display the
    expected result "Forty Eight Thousand One Hundred Eighty Five". if decimal value is less than 0.50 for example 48184.33
    then show result "Forty Eight Thousand One Hundred Eighty Four"
    so please tell me the solution
    Attached Files Attached Files
    Last edited by keshavtale; 04-26-2018 at 05:36 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Round up decimal value to one in VBA code

    Does this work?

    in A18
    =CEILING(A14+A16,1)
    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.

  3. #3
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: Round up decimal value to one in VBA code

    but i want change in VBA code

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Round up decimal value to one in VBA code

    Insert this line before your "String representation of amount" line

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    427

    Re: Round up decimal value to one in VBA code

    Thanks for solution , now my problem is solved

+ 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] decimal round pull
    By makinmomb in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-07-2017, 11:01 AM
  2. i am getting decimal value in Round numbers
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2014, 09:07 AM
  3. [SOLVED] Round 2 decimal places
    By Ventoux in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2013, 02:17 PM
  4. [SOLVED] round up to one decimal
    By rcprito in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2013, 07:17 AM
  5. Round the 4th decimal to the nearest 5 or 0
    By Zaxivette in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-14-2013, 01:57 PM
  6. Round to two decimal places
    By golfnutte in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-08-2007, 05:48 PM
  7. round a 15 digit decimal down from .05
    By Excell-ent in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2005, 10: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1