TEXT question

[jcl408]

If I wanted to have a cell do a simple subtract and then have a space and then write "percentage points" next to it, how would I do that? This is what I have so far:

=TEXT((B54-$C$51),0%)&TEXT("percentage points",0)

 

[T. Valko]

If I wanted to have a cell do a simple subtract and then have a space and then write "percentage points" next to it, how would I do that? This is what I have so far:

=TEXT((B54-$C$51),0%)&TEXT("percentage points",0)

Try this...

=TEXT(B54-$C$51,"0%")&" percentage points"

 

[T. Valko]

Try this...

=TEXT(B54-$C$51,"0%")&" percentage points"

Or, maybe this :

=B54-$C$51&" percentage points"

 

[jcl408]

Is there a way to do it without the %? I want to say like "2 percentage points" and it's showing up as 2% percentage points which is confusing

 

[jcl408]

Or, maybe this :

=B54-$C$51&" percentage points"

so this is what im looking for but its displaying a ton of decimal points. I currently have it as:

=((B54-$C$51)*100)&" percentage points"

and its displaying 1.988840372974 heh

 

[jcl408]

Got it!

=TEXT(((B54-$C$51)*100),"0.00")&" percentage points"

thanks for your help everyone

 

[T. Valko]

so this is what im looking for but its displaying a ton of decimal points. I currently have it as:

=((B54-$C$51)*100)&" percentage points"

and its displaying 1.988840372974 heh

Got it!

=TEXT(((B54-$C$51)*100),"0.00")&" percentage points"

thanks for your help everyone

Another possibility...

=ROUND((B54-$C$51)*100,2)&" percentage points"