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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

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

Trying to run excel vba code when cell value changes from empty to entered value. 1
Intrinsic Constant Value 2
Finding last constant in range 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel Need Countifs Formula Help 0
How can I test for nulls within a range without specifying each ce 2
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 1
Macro to insert a line when a value changes in a range 1

Back
Top