| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Greater Than/Less Than Question (IF statement?)
how do you create a function that returns a result (i.e. true/false) if cell
A is greater than cell B, but less than cell C? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Greater Than/Less Than Question (IF statement?)
Look in the help index for AND and then IF -- Don Guillett Microsoft MVP Excel SalesAid Software "Bill" wrote in message ... how do you create a function that returns a result (i.e. true/false) if cell A is greater than cell B, but less than cell C? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Greater Than/Less Than Question (IF statement?)
Bill,
Try =AND(A1B1,A1<C1) Mike "Bill" wrote: how do you create a function that returns a result (i.e. true/false) if cell A is greater than cell B, but less than cell C? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT | Excel Worksheet Functions | |||
| Less Than Greater Than Date Question | Excel Discussion (Misc queries) | |||
| Nested If statement to find greater than but less than numbers | Excel Worksheet Functions | |||
| Greater Than Less Than Question | Excel Worksheet Functions | |||
| If Statement Question | Excel Worksheet Functions | |||
Hybrid Mode
