Return a percentage in a cell, Not a decimal value

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Return a percentage in a cell, Not a decimal value

  1. #1
    New Member
    Join Date
    Oct 2003
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Return a percentage in a cell, Not a decimal value

     
    How do I return a percentage value in a cell. I am using Excel 2000. I need to divide the value of two cell and return the percentage with a label before it.

    I enter the formula ="Margin " &(A15/C45)

    I want the return to look like this: Margin 52%

    But, I keep getting this: Margin .52458457856

    What is wrong with my formula. Also tried to format cell for percentage, That didn't work ether.

    Thank You in advance for any help

  2. #2
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Return a percentage in a cell, Not a decimal value

    Try something like this

    Assuming value you want is in range("B2")

    MsgBox "Margin: " & Format(Range("B2").Value, "Percent")

  3. #3
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,498
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Return a percentage in a cell, Not a decimal value

    Welcome to the Board!

    Try this:

    ="Margin "&TEXT(A15/C45,"0.00%")

    Hope that helps,

    Smitty

  4. #4
    New Member
    Join Date
    Oct 2003
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Return a percentage in a cell, Not a decimal value

      
    Thank you for all your replys, Penny the formula work great!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com