formular

R

Roger Govier

Hi

=IF(AND(A1>=30,A1<=40),"No","Something else")
Replace something else with what you want if the condition is not met.
 
A

abolbashari

IF PLUS AND IS USEFUL FOR UNLIMITED LOGICAL FUNCTION BUT WITH JUST IF YOU
HAVE LIMITED.YOU CAN USE THIS IF(AND(30>A1,A1>40),A1,"NO")
 

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

Similar Threads

Replacement of "IF(OR( ))" 7
Formular for the SECOND highest frequency 8
Excel Formular 2
Second highest frequency 1
Other option for IF(AND( )) 2
What is the formula payment for $48,800 for 30 years at 8% Interes 3
Formular call to access report 5
Time Formular 4

Top