Ratios should always be presented in their simplified form. Ratios can describe quantity measurements or scale. When describing a ratio the first number is known as the antecedent and the second is the consequent.
Then the slash will be replaced with a colon to create the ratio.
In the example the active cell contains this formula. How to Recreate the Formula in Excel Here is the standard Sharpe ratio equation. Next enter 4549 into cell C2 and 159331 into cell C3. To calculate the Ratio in excel the Shop 1 will be divided by GCD and the Shop 2 will be divided by GCD.