| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating a Cell based on a Range of Values (Part II) | New Users to Excel | |||
| Populating a cell based on a range of values | New Users to Excel | |||
| auto populating a cell based on another cell for an invoice | Excel Discussion (Misc queries) | |||
| populating a cell based on another range of cells in excel | Excel Discussion (Misc queries) | |||
| Populating a field based on lookup values | Excel Worksheet Functions | |||
Linear Mode
