Download Ready-to-go Template For Calculate Ratio In Excel: DOWNLOAD NOW
- Now, let’s learn how to calculate ratio in Excel.
- What is GCD?
- Formula: =GCD(Number 1, Number 2)
- Formula: = Num1/GCD(Num1, Num2) & “:” & Num2/GCD(Num1, Num2)
- = (Number of times Number 1 contains GCD) & “:” & (Number of times Number 2 contains GCD)
- =B2/GCD(B2,C2) & ”:” & C2/GCD(B2,C2) or =B2/D2 &”:”& C2/D2 (Because We already calculated GCD(B2,C2) in cell D2. So, we can say D2= GCD(B2,C2))
- =B2/D2 &”:”& C2/D2