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″

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