IF/OR Statement

Hi,

I have attached an if/or statement that is not quite working for me. You can see from my results, that the brackets are not quite right

Thanks
Seamus
test.xls
Seamus2626Asked:
Who is Participating?
 
jppintoCommented:
Please check the attached file.

jppinto
test-IFs.xls
0
 
jppintoCommented:
Just change yourt OR's for AND's, like this:

=IF(AND(B3<30),"Under 30",IF(AND(B3>=30,B3<=60),"31-60",IF(AND(B3>60,B3<=90),"61-90",IF(AND(B3>90,B3<=120),"91-120",IF(AND(B3>=121,B3<=150),"121-150","181+")))))

jppinto
0
 
Seamus2626Author Commented:
Thanks Jppinto

Cheers,
Seamus
0
 
Pratima PharandeCommented:
try this

=IF((B3<=30);"Under 30";IF((B3<=60);"31-60";IF((B3<=90);"61-90";IF((B3<=120);"91-120";IF((B3<=150);"121-150";"181+")))))
test1.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.