Start the formula with an sign select a cell enter an operator like or then select another cell. In the first syntax divide the cell A2 with B2 and in second syntax divide cell B2 with B2 itself. Enter cell references with pointing.
A colon will be placed between those two numbers.
Calculate Ratio by using Simple Divide Method. What to Know To create a formula with references highlight the cells you want to use then select an empty cell and enter the formula. In Column B we will use a formula to check if the cells in Column C are empty or not. Calculate Ratio by using Simple Divide Method.