• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 560
  • Last Modified:

Formula and text together in Excel

I'm sorry but this is probably a really silly one. How can I put the results of a query into a string? So if I want a merged cell to read "(x)% of all student receive aid" where (x) is the result of cells A3/K68 how would i do that?
0
bpfsr
Asked:
bpfsr
  • 4
  • 2
  • 2
1 Solution
 
jeveristCommented:
Hi bpfsr,

Try this:

="(" & A3/K68  & ")% of all student receive aid"

or this:

="(" &TEXT( A3/K68*100,"#.##")  & ")% of all student receive aid"

Jim
0
 
LoNeRaVeR9Commented:
bpfsr:

You would use the TEXT function to format your calculation and then concatenate it to the text by using the ampersand.

=TEXT(A3/K68,"(0)%")&" of all student receive aid"

Kindest Regards,

Jaes
0
 
LoNeRaVeR9Commented:
Jim:

Hey there man!  Nice to see you around again!  'Course I'm just back myself, so perhaps you've been here all along...  ;)

Jaes
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Kanwaljit DhunnaCACommented:
Do You really need the brackets ? Try this, just a little change.

=TEXT( A3/B68*100,"0.00")&"% of all student receive aid"


Kanwaljit
0
 
LoNeRaVeR9Commented:
Jim and Kanwaljit:

Why are you guys multiplying by 100?  If it is a true % the TEXT function will take care of the % since it formats the result.

=TEXT(A3/B68,"0%")&" of all student rerceive aid"

<grin>

Jaes
0
 
LoNeRaVeR9Commented:
Jim and Kanwaljit:

Of course...  I assume they didn't 'rerceive' the aid.  :)

=TEXT(A3/B68,"0%")&" of all student receive aid"

Jaes
0
 
Kanwaljit DhunnaCACommented:
Hi Jaes.
You are right. I was trying to dispense with the brackets only, but seems to have overlooked % in the text function.
Kanwaljit

(But you certainly will have to pay me $10 to continue my membership ;)
0
 
jeveristCommented:
bpfsr,

And, in case you needed to do this in code, you would use the Format() function like this:

[B2].Value = Format([A3] / [K68], "0.##%") & " of all students recieve aid."

- Hey Jaes!

I'm just in and out these days.  Nice to see you back!

Jim
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now