+ Reply to Thread
Results 1 to 3 of 3

Add values with 2 decimals in a string text

Hybrid View

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    44

    Add values with 2 decimals in a string text

    Hi,

    I have the following values and text, and although I've managed to add the values in my text, I don't know how to show only 2 decimals.

    This is my formula:

    ="The owner can be "&H12*100&"% sure that the population proportion (% of customers excited about the new product) is between "&H18*100&"% and "&H19*100&"%"

    These are the values

    0.95
    0.050
    0.025
    1.960
    0.019
    0.037
    0.653
    0.727

    and this is the resulted text:

    The owner can be 95% sure that the population proportion (% of customers excited about the new product) is between 65.2993513141917% and 72.7006486858083%
    The margin of error is 3.70064868580828
    If 100 similar intervals were constructed about 99 intervals could contain the population proportion


    Thanks in advance.

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

    Re: Add values with 2 decimals in a string text

    =TEXT(H12,"0.00") should produce 2 decimal places.

    e.g.

    ="The owner can be "&TEXT(H12*100,"0.00")&"% sure that the population. . ."
    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 Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Add values with 2 decimals in a string text

    To show percentage

    =TEXT(A1,"#.00%")

    Row\Col
    A
    B
    1
    0.95
    95.00%
    2
    0.05
    5.00%
    3
    0.025
    2.50%
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. Replies: 4
    Last Post: 07-21-2014, 10:33 AM
  2. [SOLVED] Convert Numeric values with decimals to text
    By kjxavier in forum Excel General
    Replies: 1
    Last Post: 07-14-2014, 06:37 AM
  3. Replies: 1
    Last Post: 05-21-2014, 10:45 AM
  4. [SOLVED] In a text formula I need to have the numeric values with dots for thousands & 2 decimals
    By spiros63 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2012, 09:19 AM
  5. [SOLVED] Match row that contains text text string; list associated values from pivot table
    By ACurtis802 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2009, 07:50 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