Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with AND function??
I want to evaluate a value between two limits. In other words, a greater
than and less than, using an IF function. I wrote the equation: =IF(0<(fp)<100,(12/42)*qi,(6/42)*qi) for the conditions of fp greater than 0 and less than 100, but regardless of what value I use for fp, it returns the second (false) result. Obviously I have written the equation incorrectly. How should it have been written? Thanks in advance! -- PROINWV |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
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 | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |