IF Function question.
 

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<=q3t3,"value if true","value if false")

IF Function question.
 

Look in the help index for AND

=if(and(p3t3,p3<=q3),1,2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Excel beginner" <Excel wrote in message
...
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<=q3t3,"value if true","value if false")

IF Function question.
 

Look in the help index for AND

=if(and(p3t3,p3<=q3),1,2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Excel beginner" <Excel wrote in message
...
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<=q3t3,"value if true","value if false")

IF Function question.
 

Try this:

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

--
Biff
Microsoft Excel MVP


"Excel beginner" <Excel wrote in message
...
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<=q3t3,"value if true","value if false")

IF Function question.
 

Try this:

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

--
Biff
Microsoft Excel MVP


"Excel beginner" <Excel wrote in message
...
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<=q3t3,"value if true","value if false")

IF Function question.
 

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

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

Try this:

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

--
Biff
Microsoft Excel MVP


"Excel beginner" <Excel wrote in message
...
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<=q3t3,"value if true","value if false")

IF Function question.
 

On Aug 9, 5:48 am, Excel beginner
wrote:
Awesome, thanks! Would I do the same for a nested IF function?

=IF(AND(P3<=Q3,P3T3),"value if true",IF(AND(P3<=R3,P3Q3,
"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,P3T3), and(P3<=R3,P3Q3)), "value if true", "value
if false")