fomula required

[Keith]

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%.

 

[Eva]

=B3/SUM(B1:B2)
Click yes if helped

 

[Keith]

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

 

[Fred Smith]

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]

Thanks Fred, you do a marvellous job putting up with us not explaining
ourselves properly. Please accept my appology.

What I would like to find is the % that the current price is of the range.
The range I have used in the example below is (low) $66.10 - $70 (high).

(The range is $3.90 and the current price is at the top of that range so it
must be 100%) - but I can't seem to put that into an XL formula.

Hope this helps,

Keith

 

[Joe User]

(The range is $3.90 and the current price is at the top of that range so
it must be 100%) - but I can't seem to put that into an XL formula. [....]

I think you want:

=(A3-A2) / (A1-A2)

formatted as Percentage.


----- original message -----

 

[Keith]

thank you so much. works great!

(The range is $3.90 and the current price is at the top of that range so
it must be 100%) - but I can't seem to put that into an XL formula. [....]

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

I think you want:

=(A3-A2) / (A1-A2)

formatted as Percentage.


----- original message -----

Thanks Fred, you do a marvellous job putting up with us not explaining
ourselves properly. Please accept my appology.

What I would like to find is the % that the current price is of the
range. The range I have used in the example below is (low) $66.10 - $70
(high).

(The range is $3.90 and the current price is at the top of that range so
it must be 100%) - but I can't seem to put that into an XL formula.

Hope this helps,

Keith