Results 1 to 5 of 5

Thread: How to round-off nearest currently values in Microsoft Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    76

    How to round-off nearest currently values in Microsoft Excel

    I am having trouble getting either a product or sum to round to the nearest cent. How do I do this. Example 6015.54x1.4=8421.76, However when I do this in excel, it ends up being 8421.75 for some reason. Or if I choose to add 6015.54 and 2406.22 (the latter a result of multiplying the former by . It still gives me 8421.75...the actual calculation works out to 8421.756, so obviously it is just dropping the last number (or rounding it down to the nearest fifth one hundredth?). I would prefer seeing as how I am working with currency that it rounded the final number appropriately.

  2. #2
    Join Date
    Aug 2011
    Posts
    580

    Re: How to round-off nearest currently values in Microsoft Excel

    Unless you have the option "Precision as displayed" selected, XL calculates based on the stored values in the cells, not the displayed values. If your multiplicand or multiplier are calculated, they're probably not exactly 6015.54 or 1.4. You can expand the number of decimal places to find out. Working with currency should always be done with care to round appropriately at each stage. As long as you're using floating point math, there's no general way to prevent rounding errors at the end of a string of calculations.

  3. #3
    Join Date
    Aug 2011
    Posts
    540

    Re: How to round-off nearest currently values in Microsoft Excel

    Unfortunately it would appear I need the precision as displayed to be an option for individual cells thanks for the clarification at any rate.

  4. #4
    Join Date
    Aug 2011
    Posts
    695

    Re: How to round-off nearest currently values in Microsoft Excel

    On the Format menu, click Cells, and then the Number tab. In the Category list, click Currency, Accounting, Percentage, or Scientific. In the Decimal places box, enter the number of decimal places to display. To change the currency symbol, click on the symbol you want to use from the Symbol.

  5. #5
    Join Date
    Aug 2011
    Posts
    566

    Re: How to round-off nearest currently values in Microsoft Excel

    Click the Microsoft Office Button, and then click Excel Options. Click on Advanced, then during the calculation of the workbook, select the check box Set Precision as displayed and click OK. In the worksheet, select the cells you want to format. In the Home tab, click the button to display the dialog box next to Number. In the Category box, click Number. In the Decimal places box, enter the number of decimal places you want to view.

Similar Threads

  1. Replies: 2
    Last Post: 23-02-2012, 07:13 PM
  2. Custom Boolean Values in Microsoft Excel
    By Thedevotee in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 05:05 PM
  3. How to remove characters between Cell values in Microsoft Excel
    By Limitless in forum MS Office Support
    Replies: 2
    Last Post: 25-01-2012, 12:08 PM
  4. Replies: 2
    Last Post: 24-01-2012, 02:07 PM
  5. Need help on ROUND function in excel
    By Cade in forum Windows Software
    Replies: 5
    Last Post: 26-12-2009, 08:29 PM

Tags for this Thread

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
  •  
Page generated in 1,716,482,055.31507 seconds with 17 queries