IF Function question.

[Guest]

Is it possible to make an IF function's logical test be whether a number is
less than or equal a certain number, but ALSO greater than a certain number?

E.g. =IF(p3<=q3>t3,"value if true","value if false")

 

[Don Guillett]

Look in the help index for AND

=if(and(p3>t3,p3<=q3),1,2)

 

[T. Valko]

Try this:

=IF(AND(P3<=Q3,P3>T3),value if true,value if false)

 

[Guest]

Awesome, thanks! Would I do the same for a nested IF function?

 

[joeu2004]

Awesome, thanks! Would I do the same for a nested IF function?

=IF(AND(P3<=Q3,P3>T3),"value if true",IF(AND(P3<=R3,P3>Q3,
"value if true",etc.

You could; but in Excel 2003 and earlier, there is a limit of 7 nested
function calls (8, if you count the outer-most function).

If "value if true" is the same value for both conditions, you could do
something like:

=if(or(and(P3<=Q3,P3>T3), and(P3<=R3,P3>Q3)), "value if true", "value
if false")