+ Reply to Thread
Results 1 to 5 of 5

How to Make the amount round off Automatically?

  1. #1
    Registered User
    Join Date
    10-13-2014
    Location
    Bengaluru, India
    MS-Off Ver
    2013
    Posts
    18

    How to Make the amount round off Automatically?

    Screenshot_1.png

    Hello friends,

    with reference to the image attached How do I make the amount automatically round off. Example Under subtotal column (J) I have entered 3204 and in L column the amount si displayed 3204.00 + 12.36%= 3600.01 how do I make it display 3600.00 (round off)

    Like wise for any cell if the the amount is 3400.49 it should automatically display 3400.00 if it is displayed as 3400.51 than it should display as 3401.00

    So like wise if the last two units are below .50 it has to be deducted if it is fromk .51 to .99 the remaining amount should be added and the display amount should display round off.

    Please help me guys..

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,932

    Re: How to Make the amount round off Automatically?

    Use the =round function.

    Look at this link for syntax.

    http://www.techonthenet.com/excel/formulas/round.php
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: How to Make the amount round off Automatically?

    Hi if you want to change the value (rounding to zero's) use function round()

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you just want it to display right click number set decimal places to 0,
    Click just below left if it helps, Boo?ath?

  4. #4
    Registered User
    Join Date
    10-13-2014
    Location
    Bengaluru, India
    MS-Off Ver
    2013
    Posts
    18

    Re: How to Make the amount round off Automatically?

    Thanks you guys, thanks a lot for helping me out..

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,932

    Re: How to Make the amount round off Automatically?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] VBA to round off amount in coloumn C
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2013, 08:38 PM
  2. [SOLVED] Round Amount
    By yukioh in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-19-2013, 03:38 AM
  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. [SOLVED] make a letter in a cell automatically equal a dollar amount
    By kimzim in forum Excel General
    Replies: 1
    Last Post: 08-17-2005, 04:05 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