Clarke O'Donovan
Reputation: 1
How to apply rounding in Excel
I am using this formula to calculate a ratio =(A2/B2)&":"&1, the answer is correct but the answer (1.388888888889:1). How do I reduce the number of decimals to only one?
Upvotes: 0
Views: 91
Answers (1)
Redox
Reputation: 9967
You can use this...
=ROUND((A2/B2), 1)&":"&1
Output looks like this....
Upvotes: 1
Related Questions
- Rounding the given number
- How to ROUNDUP and ROUNDDOWN with IF-function
- Using ROUND after Nested IF Statements in Excel
- Excel rounding down to a specific number
- IF function in combination with an Round function Excel
- Round function (worksheet one) in Excel
- Rounding up different numbers in Excel
- Rounding in Excel
- Excel rounding up or down to specific number
- How can i Round in Excel