Change Format from Number to Percentage (sounds easy enough)
I have a simple formula that I expanded on. The problem is that I want the
second part to show as a percentage and not a number. Any ideas or suggestions on how to do this? Below is my formula. =SUM(U3:Z3) & " (" & SUM(U3:Z3)/135 & ")" Current Result: 72 (0.3613439612) Desired Result: 72 (36%) |
Change Format from Number to Percentage (sounds easy enough)
One way:
=SUM(U3:Z3) & TEXT(SUM(U3:Z3)/135," (0%)") Nonte, however, that 72 is NOT 36% of 135, so I don't have any idea how you got your original results... In article , Mike C wrote: I have a simple formula that I expanded on. The problem is that I want the second part to show as a percentage and not a number. Any ideas or suggestions on how to do this? Below is my formula. =SUM(U3:Z3) & " (" & SUM(U3:Z3)/135 & ")" Current Result: 72 (0.3613439612) Desired Result: 72 (36%) |
Change Format from Number to Percentage (sounds easy enough)
Thank worked, thanks very much.
"JE McGimpsey" wrote: One way: =SUM(U3:Z3) & TEXT(SUM(U3:Z3)/135," (0%)") Nonte, however, that 72 is NOT 36% of 135, so I don't have any idea how you got your original results... In article , Mike C wrote: I have a simple formula that I expanded on. The problem is that I want the second part to show as a percentage and not a number. Any ideas or suggestions on how to do this? Below is my formula. =SUM(U3:Z3) & " (" & SUM(U3:Z3)/135 & ")" Current Result: 72 (0.3613439612) Desired Result: 72 (36%) |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com