Display Formula Result as Percentages

[deck-b]

Hi All

I cannot reduce the decimal places in the below formula

Can anyone help?


[TABLE="width: 550"]
<colgroup><col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col width="109" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;"> <col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;"> <col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;"> <col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;"> <tbody>[TR]
[TD="width: 119, bgcolor: #4472C4"]GR's[/TD]
[TD="width: 107, bgcolor: #4472C4"]Co Product GR's[/TD]
[TD="width: 109, bgcolor: #4472C4"]Total GR's[/TD]
[TD="width: 101, bgcolor: transparent"][/TD]
[TD="width: 110, bgcolor: #4472C4"]Result[/TD]
[TD="width: 89, bgcolor: transparent"][/TD]
[TD="width: 97, bgcolor: transparent"]=(C22/E22)&":"&(D22/E2)[/TD]

[/TR]
[TR]
[TD="bgcolor: #D9E1F2"] 32,325.00 [/TD]
[TD="bgcolor: #D9E1F2"] 28,200.00 [/TD]
[TD="bgcolor: #D9E1F2"] 60,525.00 [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, colspan: 3"] 0.534076827757125:0.465923172242875
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Preferred Result[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]53%:47%[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]or[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]53:47[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Try:

=TEXT(C22/D22,"0%") & ":" & TEXT(D22/E22,"0%")

 

[Misca]

Try something like:

=TEXT(C22/E22,"0%")&":"&TEXT(D22/E22,"0%")

 

[ClaireS]

=text(c22/e22,"0%")&":"&text(d22/e22,"0%")

 

[deck-b]

Thanks everyone, that worked!