|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 20th, 2008, 05:26 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Populating a cell based on a range of values (Part III)
The formula that RagDyeR sent is working great, but now the users want to add
.1000 to the formula and I'm not sure how to do this. The formula as it is now is: =LOOKUP(A1,{0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9, 1;10,9,8,7,6,5,4,3,2,1,0}) Please let me know if this can be done. Thanks. Ken -- akkrug 
|
|
#2
June 20th, 2008, 05:30 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Populating a cell based on a range of values (Part III)
The value that they want in the result cell is 10 if the value in the table
is .100. Sorry I left that part off! Ken -- akkrug "akkrug" wrote: The formula that RagDyeR sent is working great, but now the users want to add .1000 to the formula and I'm not sure how to do this. The formula as it is now is: =LOOKUP(A1,{0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9, 1;10,9,8,7,6,5,4,3,2,1,0}) Please let me know if this can be done. Thanks. Ken -- akkrug
|
|
#3
June 20th, 2008, 09:55 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Populating a cell based on a range of values (Part III)
It already does just that.
-- __________________________________ HTH Bob "akkrug" wrote in message ... The value that they want in the result cell is 10 if the value in the table is .100. Sorry I left that part off! Ken -- akkrug "akkrug" wrote: The formula that RagDyeR sent is working great, but now the users want to add .1000 to the formula and I'm not sure how to do this. The formula as it is now is: =LOOKUP(A1,{0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9, 1;10,9,8,7,6,5,4,3,2,1,0}) Please let me know if this can be done. Thanks. Ken -- akkrug
|
|
#4
June 26th, 2008, 08:28 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Populating a cell based on a range of values (Part III)
Thanks for the help!
Ken -- akkrug "akkrug" wrote: The formula that RagDyeR sent is working great, but now the users want to add .1000 to the formula and I'm not sure how to do this. The formula as it is now is: =LOOKUP(A1,{0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9, 1;10,9,8,7,6,5,4,3,2,1,0}) Please let me know if this can be done. Thanks. Ken -- akkrug
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
