# exact fraction to text

#### Audiology

##### Board Regular
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

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### Seti

##### Well-known Member
Try this in D1

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

and welcome to the forum.

#### Kaps_mr2

##### Well-known Member
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

##### Board Regular
Seti: Thanks, perfect solution.

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

Audiology
http://rcsullivan.com

Last edited:

Replies
4
Views
548
Replies
5
Views
868
Replies
4
Views
205
Replies
8
Views
892
Replies
3
Views
916

1,191,006
Messages
5,984,126
Members
439,872
Latest member
noaman79

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back