Visit and subscribe our YouTube Channel: YouTube

Saturday, 3 March 2018

Calculate Ratio Between two Numbers In Excel Formula

Type in Cell A1 & B1 (300 & 25) in C1 Type the following formula






=A1/GCD(A1,B1)&":"&B1/GCD(A1,B1)

You Will Get Result 12:1


Any Further Queries please feel Free to Contact us:

goodwilllearningworld@gmail.com


goodwilllearningworld@outlook.com



To Download the Excel Sheet for Calculate the Ration Between Two Numbers



No comments:

Post a Comment