fomula required

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

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

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

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

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

Fred Smith" wrote in message
...
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
news
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%.

"Keith" wrote:
(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 -----

"Keith" wrote in 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

Fred Smith" wrote in message
...
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
news
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%.

thank you so much. works great!


"Joe User" joeu2004 wrote in message
...
"Keith" wrote:
(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 -----

"Keith" wrote in 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

Fred Smith" wrote in message
...
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
news 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%.