| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function termnology
I am aware that < means 'less than', that means 'more than' and that <=
means less than or equal. but how is the term 'between say1401 and 2000' written (1401 and 2000 need to be included in the numbers excel would work with)? Thank you, Colin. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function termnology
IF(AND(A2=1401,A2<=2000),"Do This",Do That")
-- Regards, Peo Sjoblom "Colin" wrote in message ... I am aware that < means 'less than', that means 'more than' and that <= means less than or equal. but how is the term 'between say1401 and 2000' written (1401 and 2000 need to be included in the numbers excel would work with)? Thank you, Colin. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function termnology
=AND(A1,<A2) assuming A1 = 1401 and A2 = 2000
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Colin" wrote: I am aware that < means 'less than', that means 'more than' and that <= means less than or equal. but how is the term 'between say1401 and 2000' written (1401 and 2000 need to be included in the numbers excel would work with)? Thank you, Colin. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
