Is there a better way? I have a bond price grid which is stated as:
104.17 which is 104 and 17/32 as a fraction(field=bondfrac)
104.18=104 and 18/32
104.19=104 and 19/32. . .etc.
I need to convert to decmial:
104.17 which is 104.53125 as a decmial (field=bonddec)
104.18=104.56250
104.19=104.59375. . .etc.
I have working. . .but seems discumbobulated.![[blush] [blush] [blush]](/data/assets/smilies/blush.gif)
Replace bondph WITH INT(bondfrac)
Replace bondtc WITH MOD(bondfrac,1)
Replace bonddec WITH (bondtc/.32)+bondph
Any feedback is appreciated. . .
104.17 which is 104 and 17/32 as a fraction(field=bondfrac)
104.18=104 and 18/32
104.19=104 and 19/32. . .etc.
I need to convert to decmial:
104.17 which is 104.53125 as a decmial (field=bonddec)
104.18=104.56250
104.19=104.59375. . .etc.
I have working. . .but seems discumbobulated.
![[blush] [blush] [blush]](/data/assets/smilies/blush.gif)
Replace bondph WITH INT(bondfrac)
Replace bondtc WITH MOD(bondfrac,1)
Replace bonddec WITH (bondtc/.32)+bondph
Any feedback is appreciated. . .