If formula

[adn4n]

In a formula how do i say, larger than 56 but smaller than 420... o
larger than 56 AND smaller than 420

 

[Frank Kabel]

Hi
something like
=IF(AND(A1>56,A1<420),"Yes","No")