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
|