Re: Help with Spreadsheets and 32nds?

[Stewart Taylor <staylor@xxxxxxx>]

=(N4-INT(N4))*0.32+(INT(N4))  This should do it. Seperates the integer,
makes the decimal to 32/ and adds the integer back.  Ive used this formula
for years.  Sounds like there may be a way to do it more easily, but just
in case. 


Stewart.   


At 09:37 PM 10/6/98 -0500, Timothy Morge wrote:
>Folks...
>
>I am trying to do some spreadsheet work to clarify a few ideas I have in the
>bond markets. I want to use Excel [or any other spreadsheet program] and I
>wondered if there is a way to deal with prices that will leave them in
32nds and
>also give me my answers in 32nds? There must be a way to do this, and I
hope the
>answer is so simple I'll feel follish when I read your tips...
>
>Thanks in advance for your help and comments.
>
>Best,
>
>Tim Morge
>
>
Stewart Taylor
Taylor Fixed Income Outlook
Voice: 501-219-9774
Fax: 501-228-0963
E-Mail: staylor@xxxxxxx
Web Site: http://www.cei.net/~staylor/