exact fraction to text

[Audiology]

I use a custom format (#??/16) to convert the integer contents of two cells to a fraction so that A1=16, B1= 16 , then target cell (C1) displays 16/16 (or a fraction thereof in sixteenths without the least common denominator kicking in) i.e., not 1.

I need to convert that exact fraction displayed in C1 to text in D1 order to concatenate it with a string in E1 and display the concatenated string in F1.

Ideas?

Audiology

 

[Seti]

Try this in D1

=TEXT(A1/B1,"#??/16")

and welcome to the forum.

 

[Kaps_mr2]

Set up an array

a1= "one sixteenth"
b1 = "two sixteenths"
c1 = "three sixteenths"
d1 = "four sixteenths" etc


and if your numerator is in say cell C2 :-

INDEX($a$1:$p$1,c2)

will return the correct phrase. Thanks

Kaps

 

[Audiology]

Seti: Thanks, perfect solution.

Kaps, Thanks for responding. I should have been more specific.


Audiology
http://rcsullivan.com