+ Reply to Thread
Results 1 to 2 of 2

Formula to convert 0.976565666 to 0.98

  1. #1
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Formula to convert 0.976565666 to 0.98

    HI All,
    I have a calculation where i am calculating a differnece of two % values and would like to return only to one decimal place . For example 1-.22 =0.78 . I need to only show upto 0.7. I know I can handle the same in formatting but the reason I need to change the value itself is that I need to use it in a report filter and there, excel is reading the complete value.

    Any pointers will help. I tried Round, roundup and rounddown, but i think either they are not helpful since this is diff of % values, so in all cases it is less than 1 or I am doing something wrong.

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Formula to convert 0.976565666 to 0.98

    welcome to the forum. not sure what went wrong with your formula? it is a bit contradicting though. your title says to convert 0.976565666 to 0.98. that is either a roundUP to 2 decimal places or simply ROUND to the nearest 2 decimal place. but for 0.78 to become 0.7 is a roundDOWN. percentages can be rounded too.

    so to roundUP 0.976565666 to 0.98 is
    =ROUNDUP(A1,2)

    ROUND:
    =ROUNDUP(A1,2)

    ROUNDDOWN:
    =ROUNDDOWN(A1,2)

    with your equation of 1-0.22, it could be:
    =ROUNDDOWN(1-0.22,2)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

+ 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] Convert formula to VBA code without viewing the formula in Cell
    By KumarPK in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-24-2016, 11:02 AM
  2. Replies: 8
    Last Post: 09-29-2016, 08:21 AM
  3. Convert Cell Formula to Convert Text to VBA Code
    By PY_ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2014, 05:51 PM
  4. Formula as text in cell -> convert to formula result
    By AHFoddeR in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-12-2013, 02:00 AM
  5. [SOLVED] Need to Convert Formula R1C1 into A1-style but the Formula String exceeds 255 characters
    By VBA_Gary in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-04-2012, 12:09 PM
  6. Replies: 3
    Last Post: 05-18-2010, 06:14 AM
  7. [SOLVED] how to convert a formula into text in order to display the formula
    By Claudio Hartzstein in forum Excel General
    Replies: 2
    Last Post: 07-13-2006, 05:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1