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]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!