Results 1 to 4 of 4

Thread: Number format in formula with text

  1. #1

    Number format in formula with text



    Register for a FREE account, and/
    or Log in to avoid these ads!

    How do I get the latter sum of this formula to return the value in percentage, not as a decimal number:

    ="No of girls: "&(SUM(AT2:AT260))&" / % girls:"&((SUM(AT2:AT260)/(SUM(AS2:AS260))))

    I.e. as result I would want:
    No of girls: 3 / % girls: 43 %

    NOT
    No of girls: 3 / % girls:0.428571428571429

    Is it even possible?

    Thanks folks!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,490
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    ="No of girls: "&(SUM(AT2:AT260))&" / % girls:"&TEXT((SUM(AT2:AT260)/(SUM(AS2:AS260))),"0.###%")


  3. #3
    Works. Brilliant, thank you!

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,490
    Articles
    0
    Excel Version
    Excel 2016
    You're welcome


Tags for this Thread

Posting Permissions

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