Learn About Ratio Calculation In Excel In Detail.

Asked By 0 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 0 points N/A #299469

Learn About Ratio Calculation In Excel In Detail.

qa-featured

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.

Image result for ratio calculation in excel

Related Questions