fomula required

  • Thread starter Thread starter Keith
  • Start date Start date
K

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%.
 
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
 
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
 
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
 
Keith said:
(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. [....]
Click to expand...

I think you want:

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

formatted as Percentage.


----- original message -----
 
thank you so much. works great!


Joe User said:
Keith said:
(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)
Click to expand...
Click to expand...

I think you want:

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

formatted as Percentage.


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

Keith said:
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
Click to expand...
Click to expand...
 
Back
Top