IF function

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
 
J

Jacob Skaria

Use AND()

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

If this post helps click Yes
 
P

Phil

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.
 
J

Jacob Skaria

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
 
D

David Biddulph

In which case, please enter the formula with matching sets of parentheses,
as Jacob did.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top