Creating Ratio's in Excel

[Glenn Johnson]

How do you create a formula that will take two cells
values and show them as a ratio?
E.G. A2=100
B2=25
C2=formula to show 4:1

Thanks for any help.

Glenn

 

[Dave Peterson]

Could you live with 4/1?

If yes, then use a formula like =a2/b2, but format the cell as a fraction.
There's lots of options for how many digits to show in the dialog.

If you've got to have the colon:

=substitute(text(a2/b2,"??/??"),"/",":")

Use as many ? as you want.

(But that second option is now text.)