How can i make this work within an IF statement: (41<=Cell<=46)
 

Everytime i type that condition into an if statement it doesnt calculate the
number correctly... what am i doing wrong?

One way:
=if(and(a1=41,a1<=46),"it's between","outside")



velopoav wrote:

Everytime i type that condition into an if statement it doesnt calculate the
number correctly... what am i doing wrong?

--

Dave Peterson

You don't tell us what formula you used.
But probably you mean something like

=IF(AND(A1=41,A1<=46),"yes","no")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"velopoav" wrote in message
...
Everytime i type that condition into an if statement it doesnt calculate
the
number correctly... what am i doing wrong?

You can also use boolean conditions like:

=(A11) * 1 - checks one condition

=(A12) * (A1<8) * 1 - both conditions must be true

However, this type of conditioning does not work with text.

A more detailed explanation can be found he

http://www.pdbook.com/index.php/exce...itch_formulas/

----
Regards,
John Mansfield
http://www.pdbook.com



"velopoav" wrote:

Everytime i type that condition into an if statement it doesnt calculate the
number correctly... what am i doing wrong?