How can I have a range of values select a constant value

's Computer Specifications

If I enter a value in column a that falls between a given range, how can I
have a constant value appear in column b. For example if cell a5 is greater
than 10 but less than 15 enter 12 in cell b5.

's Computer Specifications

Is this an Access question or an Excel question? Your post is in an Access
newsgroup, but you are referring to Cells. Access has no Cells. If this is
an Excel question, I suggest you repost in an Excel news group. If it is an
Access question, repost with the correct terminology and you will surely get
some assistance.

"John T" wrote:

> If I enter a value in column a that falls between a given range, how can I
> have a constant value appear in column b. For example if cell a5 is greater
> than 10 but less than 15 enter 12 in cell b5.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select Range from column values	Maarkr	Microsoft Access	1	7th Oct 2009 03:13 PM
Shift constant values in a range left or right by n columns	Dirk Goldgar	Microsoft Excel Programming	2	21st Jul 2008 07:09 PM
RE: Searching a date range to output values according to a constant.	=?Utf-8?B?ZHJpbGxlcg==?=	Microsoft Excel Misc	0	1st Dec 2006 02:32 AM
Assign a 2D array of constant values to a range	dodgo	Microsoft Excel Programming	4	19th Oct 2006 04:46 AM
using cell values to select range of cells	Ray	Microsoft Excel Programming	4	10th Oct 2003 08:31 AM