if statement is not workin - says too many arguments

**jenns** · 05-16-2014, 09:13 PM

Hello

I could use someone's help

Im trying to put an if statement that says

if (cell) is less than -5, (cell) greater than 5 say met
if (cell) is greater than -5, (cell) and less than 5 say not met

=IF(AND(T3<-5,T3>5),"NOT MET","MET",IF(AND(T3>-5,T3<5),"NOT MET","MET"))

I've tried to put one ) and 2 )) - I'm not sure what I'm doing wrong

thanks
Jenn

**AlKey** · 05-16-2014, 09:25 PM

maybe this

=IF(AND(T3<-5,T3>5),"NOT MET",IF(AND(T3>-5,T3<5),"NOT MET","MET"))

**benishiryo** · 05-16-2014, 09:29 PM

welcome to the forum, Jenn.

1. when you say less than -5, is -6 one eg? and greater than 5 would be 6? if so, you should be using OR and not AND. because -6 is not less than -5 AND greater than 5.

2. how about the exact value of -5 and 5? you didnt give a scenario for that

3. if you noticed when typing your formulas, there is a screen tip which bolds the part you are supposed to key. when you key up to this point:
=IF(AND(T3<-5,T3>5),"NOT MET","MET",
the screen tip does not have any more fields for you to key after the comma. that's where you know your formula is already wrong.

if i were to assume -6 OR 6 is considered MET, -5 to 5 (the number -5 & 5 itself too) is NOT MET, then:
=IF(OR(T3<-5,T3>5),"NOT MET","MET")

if the cell is a blank, it is considered as 0. so it is between -5 to 5. if you don't wish to show a MET and show as blank instead,
=IF(T3="","",IF(OR(T3<-5,T3>5),"NOT MET","MET"))