It may be obvious to you, but it's not obvious to us. If you want the % that
the current price is of the high (which is the only one which gives the 100%
in your example), then you want:
=a3/a1

If you want something else, explain what range calculation you want.
Examples are good, as well as what answer you want from the example.

Regards,
Fred

"Keith" wrote in message
...
From the formula supplied, it doesn't seem to work properly if I change
the numbers, eg.

A1: $70 (a stock high)
A2: $66.10 (a stock low)
A3: $70 (current price)

It gives an answer of 51% when it obviously should read 100%.

Am I missing something here?

Keith

"Eva" wrote in message
...
=B3/SUM(B1:B2)
Click yes if helped
--
Greatly appreciated
Eva


"Keith" wrote:

I'm attempting to get a formula to reflect as a %.

A1: $4 (a stock high)
A2: $2 (a stock low)
A3: $3 (current price)

How can I get a formula to show the current price of the range as a %,
in
this case it would show 50%.