A small pop tab should appear. To calculate the Ratio in excel the Shop 1 will be divided by GCD and the Shop 2 will be divided by GCD. Ratios can describe quantity measurements or scale.
Be sure that Analysis ToolPak is selected.
GCD Function to Calculate Ratio in Excel. Previous years quick ratio was 14 and the industry average is 17. Typically this ratio is shown as x1 or like this The custom number format applied to the current ratio is set by using FormatCellsNumber. To show the result of division as a ratio you can use a custom number format.