Setting A Number Equal to Another Number

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

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

Any help is greatly appreciated.


--
slag018
------------------------------------------------------------------------
slag018's Profile: http://www.excelforum.com/member.php...o&userid=15432
View this thread: http://www.excelforum.com/showthread...hreadid=270348

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.

On Mon, 18 Oct 2004 22:05:21 -0500, slag018
wrote:


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

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

Any help is greatly appreciated.