ratio proportion formula in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
put 12 in A1 and 42 in B1 and put =A1/B1 in C1.

To display as a ratio, select C1 and format:

Format > Cells... > Fraction and pick a selection.
 
Back
Top