Hi there,

No doubt this is a simple one for many......I require a formula the following:

I have 3 prices: e.g.
Last 1.25
High 1.50
Low 1.00

Any body have an idea what formula is used to display as a % the Last price (1.25) in relation to the range between the high (1.50) and low (1.00) price?

Thanks in advance for any assistance.

Adam