Asked By
lebe dayes
0 points
N/A
Posted on - 06/15/2017
Hi everyone,
I want to know about ratio calculation in excel. If anyone is having any clue about the formula or other, please let me know.
Please reply.
Thank you in advance.
Learn About Ratio Calculation In Excel In Detail.
If you wish to calculate the ratio of two numbers in Microsoft Excel, you can use the Greatest Common Divisor function or the TEXT and SUBSTITUTE functions for this purpose.
For calculating the ratio, you must divide the width by the GCD and the height also by the GCD. Additionally, a colon can be put between the numbers.
To get the ratio in above example, input this formula in cell E4:
The result is 4:3, which is the ratio for those dimensions.