IF statement (non nested) that compares cell value against range
 

Is it possible to write a non-nested IF statement that looks something like

IF(A2=10 AND A2<100,"10-100","") or IF(a2 is between 10 and 100,"10-100","")

IF statement (non nested) that compares cell value against range
 

=if(and(A2=10, A2<100),"10-100","")

"r2d3" wrote:

Is it possible to write a non-nested IF statement that looks something like

IF(A2=10 AND A2<100,"10-100","") or IF(a2 is between 10 and 100,"10-100","")

IF statement (non nested) that compares cell value against range
 

yes

"r2d3" a écrit dans le message de news:
...
Is it possible to write a non-nested IF statement that looks something
like

IF(A2=10 AND A2<100,"10-100","") or IF(a2 is between 10 and
100,"10-100","")

IF statement (non nested) that compares cell value against ran
 

Thank you.

"Duke Carey" wrote:

=if(and(A2=10, A2<100),"10-100","")

"r2d3" wrote:

Is it possible to write a non-nested IF statement that looks something like

IF(A2=10 AND A2<100,"10-100","") or IF(a2 is between 10 and 100,"10-100","")

IF statement (non nested) that compares cell value against range
 

You are close in your attempt. Try this:

=IF(AND(A2=10,A2<=100),"10-100","")

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=567952