Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Controlling Decimal points in Formula
Hi! I'm puzzled...thanks for any help!
I have set up a formula to show a calculated % between parentheses. Working great, but now would like to round out result to 1 decimal point. Since I think I've converted to text using "", I can't use Excel's normal decimal point tool. I'm getting "ugly looking" results like (30.333333333333%). I'd like it to show (30.3%). Here's my formula, which yields (70%), given the data example below. ="("&A1/SUM(B1:B5)%&"%"&")" A B 1 50 10 2 5 3 10 4 5 5 5 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Controlling Decimal points in Formula
Try
="("&ROUND((A1/SUM(B1:B5)%),1)&"%"&")" Hope this helps, Hutch "Stilla" wrote: Hi! I'm puzzled...thanks for any help! I have set up a formula to show a calculated % between parentheses. Working great, but now would like to round out result to 1 decimal point. Since I think I've converted to text using "", I can't use Excel's normal decimal point tool. I'm getting "ugly looking" results like (30.333333333333%). I'd like it to show (30.3%). Here's my formula, which yields (70%), given the data example below. ="("&A1/SUM(B1:B5)%&"%"&")" A B 1 50 10 2 5 3 10 4 5 5 5 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Controlling Decimal points in Formula
TONY!!!! You're a genius! THANKS!
"Tom Hutchins" wrote: Try ="("&ROUND((A1/SUM(B1:B5)%),1)&"%"&")" Hope this helps, Hutch "Stilla" wrote: Hi! I'm puzzled...thanks for any help! I have set up a formula to show a calculated % between parentheses. Working great, but now would like to round out result to 1 decimal point. Since I think I've converted to text using "", I can't use Excel's normal decimal point tool. I'm getting "ugly looking" results like (30.333333333333%). I'd like it to show (30.3%). Here's my formula, which yields (70%), given the data example below. ="("&A1/SUM(B1:B5)%&"%"&")" A B 1 50 10 2 5 3 10 4 5 5 5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Points | New Users to Excel | |||
How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
Formatting Decimal points | Excel Discussion (Misc queries) | |||
Decimal Points | Excel Worksheet Functions | |||
Decimal points not needed | Excel Worksheet Functions |