Converting gradients - % to degrees to ratios

do you want to convert say 45 degrees slope to a ratio/percent?
if so
Degrees of slope/90 x 100 will give % 45/90 =1/2 i.e 1 in 2
if you have the analysis toolpak activated
then as a ratio try
=A1/GCD(A1,B1) &":"& B1/GCD(A1,B1)
when a1=1 b1=2 result is 1:2
where a1 is numerator b1 denominator