| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula if a number is between 2 amount than answer will be x
I need help please!!! For example if I am in cell C3. I want to put a formula
in that if in B3 the number I have entered is between 4 and 6 for example than i want the answer in C3 to be 2. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula if a number is between 2 amount than answer will be x
"Princess" wrote:
I want to put a formula in that if in B3 the number I have entered is between 4 and 6 for example than i want the answer in C3 to be 2. You also need to specify what value you want if B3 is not between those limits. I will use 1 .... =IF(AND(4<=B3,B3<=6), 2, 1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| formula for inverse tan of a number with answer in degrees | Excel Discussion (Misc queries) | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
