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.


1 50 10
2 5
3 10
4 5
5 5

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question