I have figured out that there are four different ways to calculate the ratio in Excel but using a simple divide method is the easiest one. All you need to do is divide the larger number into the smaller ones and concatenate it with a colon and one and here’s the formula you need to use:
=Larger-Number/Smaller-Number&”:”&”1″
![excel tips tricks to use simple divide to calculate ratio in excel](https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/images/optimized/rev-a53ee6c/wp-content/uploads/2018/05/excel-tips-tricks-to-use-simple-divide-to-calculate-ratio-in-excel.png)
This formula divides the larger number by the smaller one so that you can take the smaller number as a base (1).
No comments:
Post a Comment