How is your data represented?
If you have text consisting of some digit(s) followed by a "/" followed by "16":
- The FIND function will tell you where the "/" is.
- The LEFT function will let you extract the digit(s) before the "/".
- Dividing this by 100 will get you the decimal representation.
- =LEFT(text_cell,FIND("/",text_cell)-1)/100
If you have text with different denominators, you will need scale based on the denominator. 16 would need x1, 8 x2, 4 x4, 2 x8. After using FIND as above:
- The MATCH function will locate a value in an array.
- The INDEX function will select a value in an array.
- =LEFT(text_cell,FIND("/",text_cell)-1)*INDEX({1,2,4,8},MATCH(TEXTAFTER(text_cell,"/"),{"16","8","4","2"},0))/100
Alternately, you can convert the text fraction to a decimal value:
- =LEFT(text_cell.FIND("/",text_cell)/TEXTAFTER(text_cell,"/")
When the cell contains a decimal value (either originally or from the preceding conversion), the ROUNDUP function can provide the desired value:
- =ROUNDUP(decimal_cell*16,0)/100