Setting A Number Equal to Another Number

S

slag018

I was wondering if I could set a cell with one number equal to anothe
number in another cell. I am having a hard time trying to explain wha
I mean so I try to use an example.

For example i have the number .93 in cell B3. I want the number i
cell C3 to depend on the number in B3. For example if the number i
between .90 and 1 I want the number in C3 to be 4, if the number i
between .80 and .90 I want the number in C3 to be 3, and so on. Th
number in cell B3 does change, so I want the number in C3 to chang
based on the change of B3.

Any help is greatly appreciated
 
M

Myrna Larson

Create a table: the first column contains your cutoff values, in ASCENDING
order. If you have criteria for .1, .2, .3, etc the table would look like this

0 ?
.1 ?
.2 ?
.3 ?
.4 ?
.5 ?
.6 ?
.7 ?
.8 3
.9 4

Let's say you put that table over in K1:L10, and you fill in the question
marks. Then in C3 the formula is

=VLOOKUP(B3,$K$1:$L$10,2)

If you don't need numbers in the first column below, say 0.7, you can delete
the rows for 0.1 through 0.6. But, assuming you never have a negative number
in B3, I would leave the row with the 0.
 
Top