IF function

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Can I use the "if" function to determine if a cell contains a value that is
"greater than 1 but equal to or less than 5"?

eg....

if b4 >1 <=5
IF TRUE....
IF FALSE...

Thanks in advance.
Phil
 
Use AND()

=IF(AND(B4>1,B4<=5),"condition is true","is false")

If this post helps click Yes
 
Jacob, many thanks, that certainly shows the result but when I do the final
enter it tells me I am missing a parenthesis or the like....apologies for
being such a dummy.
 
Why dont you post your formula..

'the below returns B4 if true else return blank
=IF(AND(B4>1,B4<=5),B4,"")

If this post helps click Yes
 
Back
Top