Multiple Functions for One Cell?

  • I have a number... 131'120 this is a 10 Yr Note future price


    I need to convert this price to a ratio


    The price reads 131 by 12 even the 10 yr being quoted in half ticks
    so I need to have the cell perform 131 + 12/32 = Ratio


    I need to be able to enter the price then have it convert


    Is this possible?


    if B1 is blank but has the function already waiting
    how to enter the 131 then the 12?



    I hope that makes sense

  • Re: Multiple Functions for One Cell?


    I'm guessing at what you are looking to do. Assume you enter data in A1, then in B1 is the result based upon the formula shown. Not really sure what you are asking as you are using some technical terms for that I am unfamiliar with.


    Data Range
    [TABLE="class: grid"]

    [tr]


    [td][/td]


    [td]

    A


    [/td]


    [td]

    B


    [/td]


    [td]

    C


    [/td]


    [td]

    D


    [/td]


    [/tr]


    [tr]


    [td]

    1


    [/td]


    [td]

    131'120


    [/td]


    [td]

    131.375


    [/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    2


    [/td]


    [td][/td]


    [td]

    '=LEFT(A1,3)+MID(A1,5,2)/32


    [/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]