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
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Setting combo box default value to equal same as previous form. | Jbetance | Using Forms | 1 | September 18th, 2004 09:05 PM |
Number of Mondays in month | Michael Noblet | Setting Up & Running Reports | 3 | July 28th, 2004 10:41 PM |
Counting number of occurrances | martin | Worksheet Functions | 0 | January 8th, 2004 12:19 AM |