Auto "convert" a number to a different number
 

I have a cell that will display a number, i.e. 0.25, by the use of the
formula =LARGE(P3:P43,1). I want to use this cell in a division formula in a
second cell, but when inserted into the second formula, I want the 0.25 to be
"converted" to 0.9. I don't want to change the appearance of the first cell
(still want it to show 0.25), but I want 0.9 to be used in the second
formula. The range of numbers that can show up in the first cell are from
0.15 to 0.75. The range of "converted" numbers are from 1 to 0.4.

0.15 = 1
0.16 = 0.99
0.17 = 0.98
0.18 = 0.97
and so on and so on :)

Is it possible to do what I am asking?
Thank you

Auto "convert" a number to a different number
 

Hi Rick

assuming you have 2 columns on Sheet2 with your values in column A and the
values you want to use in column B, then
=VLOOKUP(LARGE(P3:P43,1).,Sheet2!$A:$B,2,0)

should return the value you need to use.


--
Regards
Roger Govier

"Rick" wrote in message
...
I have a cell that will display a number, i.e. 0.25, by the use of the
formula =LARGE(P3:P43,1). I want to use this cell in a division formula in
a
second cell, but when inserted into the second formula, I want the 0.25 to
be
"converted" to 0.9. I don't want to change the appearance of the first
cell
(still want it to show 0.25), but I want 0.9 to be used in the second
formula. The range of numbers that can show up in the first cell are from
0.15 to 0.75. The range of "converted" numbers are from 1 to 0.4.

0.15 = 1
0.16 = 0.99
0.17 = 0.98
0.18 = 0.97
and so on and so on :)

Is it possible to do what I am asking?
Thank you

Auto "convert" a number to a different number
 

Rick

I would set your conversions up in a second table, even on another sheet and
then refer to that, so if your original number is in A1 on sheet 1 and the
table of conversions in say A1:B100 on sheet2 then something like

=Your_new_number/VLOOKUP(A1,Sheet2!$A$1:$B$100,2,FALSE)

Replace Your_New_Number with the reference to the cell with your other
number in

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"Rick" wrote in message
...
I have a cell that will display a number, i.e. 0.25, by the use of the
formula =LARGE(P3:P43,1). I want to use this cell in a division formula in
a
second cell, but when inserted into the second formula, I want the 0.25 to
be
"converted" to 0.9. I don't want to change the appearance of the first
cell
(still want it to show 0.25), but I want 0.9 to be used in the second
formula. The range of numbers that can show up in the first cell are from
0.15 to 0.75. The range of "converted" numbers are from 1 to 0.4.

0.15 = 1
0.16 = 0.99
0.17 = 0.98
0.18 = 0.97
and so on and so on :)

Is it possible to do what I am asking?
Thank you

Auto "convert" a number to a different number
 

=1-Q5+0.15

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Rick" wrote in message
...
I have a cell that will display a number, i.e. 0.25, by the use of the
formula =LARGE(P3:P43,1). I want to use this cell in a division formula in
a
second cell, but when inserted into the second formula, I want the 0.25 to
be
"converted" to 0.9. I don't want to change the appearance of the first
cell
(still want it to show 0.25), but I want 0.9 to be used in the second
formula. The range of numbers that can show up in the first cell are from
0.15 to 0.75. The range of "converted" numbers are from 1 to 0.4.

0.15 = 1
0.16 = 0.99
0.17 = 0.98
0.18 = 0.97
and so on and so on :)

Is it possible to do what I am asking?
Thank you

Auto "convert" a number to a different number
 

Thank you gentlemen, that worked perfectly !!! I am truely grateful :)

"Roger Govier" wrote:

Hi Rick

assuming you have 2 columns on Sheet2 with your values in column A and the
values you want to use in column B, then
=VLOOKUP(LARGE(P3:P43,1).,Sheet2!$A:$B,2,0)

should return the value you need to use.


--
Regards
Roger Govier

"Rick" wrote in message
...
I have a cell that will display a number, i.e. 0.25, by the use of the
formula =LARGE(P3:P43,1). I want to use this cell in a division formula in
a
second cell, but when inserted into the second formula, I want the 0.25 to
be
"converted" to 0.9. I don't want to change the appearance of the first
cell
(still want it to show 0.25), but I want 0.9 to be used in the second
formula. The range of numbers that can show up in the first cell are from
0.15 to 0.75. The range of "converted" numbers are from 1 to 0.4.

0.15 = 1
0.16 = 0.99
0.17 = 0.98
0.18 = 0.97
and so on and so on :)

Is it possible to do what I am asking?
Thank you