Convert fractions to decimals

Jason R

I'm looking for a formula that I can use to convert (15 1/4 to 15.25) or (15 1/16 to 15.0625)

Paul Newcome

It is possible. We can leverage the "/" to pull the character(s) from the left and divide by the character(s) on the right (after converting each to a numerical value).

To get the left side:

=VALUE(LEFT([Width Fraction]@row, FIND("/", [Width Fraction]@row) - 1))

To pull the right is a little "out of the box" thinking:

=VALUE(SUBSTITUTE([Width Fraction]@row, LEFT([Width Fraction]@row, FIND("/", [Width Fraction]@row)), ""))

Divide left by right, and you should be good to go:

=VALUE(LEFT([Width Fraction]@row, FIND("/", [Width Fraction]@row) - 1)) / VALUE(SUBSTITUTE([Width Fraction]@row, LEFT([Width Fraction]@row, FIND("/", [Width Fraction]@row)), ""))

Paul Newcome

How is it displayed in the cell?

If you are looking to manually enter everything, it would look something along the line of

=15 + 1 / 4

or

=15 + 1 / 16

Jason R

I am using a beta form in the field to enter cabinet door sizes and am wanting to convert to a decimal in order to calculate sq ft. I was able to do it long hand but was hoping there was a way that when then entered 1/16 it would automatically convert it when added to my sheet.

Paul Newcome

It is possible. We can leverage the "/" to pull the character(s) from the left and divide by the character(s) on the right (after converting each to a numerical value).

To get the left side:

=VALUE(LEFT([Width Fraction]@row, FIND("/", [Width Fraction]@row) - 1))

To pull the right is a little "out of the box" thinking:

=VALUE(SUBSTITUTE([Width Fraction]@row, LEFT([Width Fraction]@row, FIND("/", [Width Fraction]@row)), ""))

Divide left by right, and you should be good to go:

=VALUE(LEFT([Width Fraction]@row, FIND("/", [Width Fraction]@row) - 1)) / VALUE(SUBSTITUTE([Width Fraction]@row, LEFT([Width Fraction]@row, FIND("/", [Width Fraction]@row)), ""))

Elizabeth Aird

i ended up creating an index/match to another sheet. where it gets a bit hairy is when I have mixed number.