H:V format

[afrexico]

I wanted to know if there is a way for Excel to present a grade slope as H:V, i.e. 0.25 as 4:1 slope?

 

[GlennUK]

How about:

=MID(TEXT(A1," 0/0"),FIND("/",TEXT(A1," 0/0"))+1,999)&":"&TRIM(MID(TEXT(A1," 0/0"),1,FIND("/",TEXT(A1," 0/0"))-1))

assuming the 0.25 is in cell A1.

Or even:
=TRIM(MID(TEXT(A1," ??/??"),FIND("/",TEXT(A1," ??/??"))+1,999))&":"&TRIM(MID(TEXT(A1," ??/??"),1,FIND("/",TEXT(A1," ??/??"))-1))
to cope with a wider range of numbers.

 

[West Man]

Would =1/A1&":1" do it?

 

[afrexico]

Thank you for your replies. They all work. As far as the last response it did work but with odd decimals it give a very long number XXXXXX:1 result.

 

[West Man]

If you like the shorter formula, you can reduce the numbers after the decimal to 3 by using =TEXT(1/A1,"####.###")&":1"

 

[Scott Huish]

Or you could incorporate it into the TEXT function:

=TEXT(1/A1,".0##\:1")