Convert fractions to decimals

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)

Best Answer

Answers

  • Paul Newcome
    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
    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.

  • Elizabeth Aird
    Elizabeth Aird ✭✭✭✭

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!