Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2004
    Location
    Albuquerque, New Mexico, USA
    Posts
    233
    Thanks
    0
    Thanked 1 Time in 1 Post

    Show formula result with text (2003 SP2)

    Say that the value of =large(a4:a100) is 38. I want to display the results of =large(a4:a100) in b40 along with text, like: "Largest found was 38". I can't seem to figure out a way to do this in one cell.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show formula result with text (2003 SP2)

    Try

    ="Largest found was "&Large(A4:A100)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show formula result with text (2003 SP2)

    Or, if you want the cell contents to be a number (available for further calculations), keep your formula and set a custom format

    "Largest found was"0

  4. #4
    3 Star Lounger
    Join Date
    Apr 2004
    Location
    Albuquerque, New Mexico, USA
    Posts
    233
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Show formula result with text (2003 SP2)

    Perfect! Thanks, Hans, this is exactly what I needed.

    (Where in Help is this explained? I tried several terms without success.)

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show formula result with text (2003 SP2)

    I don't think there is a specific help subject for this. You could look up concatenate in the help.

Posting Permissions

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