Results 1 to 4 of 4

Force excel to give the desired result

Threaded View

  1. #1
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    1,029

    Force excel to give the desired result

    If you divide 10 by 3 the result is 3.3 recurring. 3.3 is the answer I require, with just one decimal place. End of.

    However later I can end up with 3.3 + 3.3 + 3.3 =10 when I need it to equal as seen, 9.9.

    Is there a way to do this? A way to convert 3.3 recurring to just 3.3 or do I have to enter it manually?

    I obviously know you can format the cell to show just one decimal place but in this instance it doesn't help.

    Many thanks.
    Attached Files Attached Files
    Last edited by Marvo; 09-27-2021 at 03:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Added front end and now formulas give errors instead of the desired N/A
    By billfinnjr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-13-2018, 11:21 AM
  2. [SOLVED] excel RandBetweenInt always give same result
    By caabdul in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-20-2018, 02:07 AM
  3. [SOLVED] Ignore blank cell to give give non zero result
    By rehan0129 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2018, 12:04 PM
  4. [SOLVED] Need Help with a Formula to compare and give desired result
    By JennOlsen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-02-2018, 01:55 PM
  5. can Sql query runs itself and paste result directly in the desired excel cells?
    By raksha1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2014, 05:51 AM
  6. Look at text file, and produce a new result set based desired format in the excel
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2013, 01:10 PM
  7. How To Compare Two Excel Sheets & Get Desired Result In Third Sheet!!
    By bmiguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2013, 12:30 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