Populating a cell based on a range of values (Part III)

A

akkrug

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
 
A

akkrug

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populating a Cell based on a Range of Values (Part II) 6
Populating a cell based on a range of values 2
group values based on a range using IF function 1
Changing items in cells that are filled using Data Validation List 2
Would like to input 3 letters into a cell, each having a different numerical value 5
sum based on value in a range 0
The sum of the same function that is used for a range of cells 2
Count Values in a Range, Not Formulas 2

Top