Seamus2626
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Jppinto
Cheers,
Seamus
Cheers,
Seamus
try this
=IF((B3<=30);"Under 30";IF((B3<=60);"31-60";IF ((B3<=90); "61-90";IF ((B3<=120) ;"91-120"; IF((B3<=15 0);"121-15 0";"181+") ))))
test1.xls
=IF((B3<=30);"Under 30";IF((B3<=60);"31-60";IF
test1.xls
=IF(AND(B3<30),"Under 30",IF(AND(B3>=30,B3<=60),
jppinto