I have a column say "Name" with values "XXX" "YYY" and "ZZZ" and another column say "Status " with values as "Approve" and "Reject". i should create a calculated column to show the result as "approved" only if Name="XXX" or "YYY" and Status = "Approve". else it should show "rejected". Tried this and seems to be not working. =IF(AND([Status]="Approve", (IF(OR([name]="XXX","YYY")))),"approved","rejected") Pls help !!!

Try the following. =IF(OR([Status]="Approve",[Title]="XXX",[Title]="YYY"),"approved","rejected") It worked for me.V

Thanks for the reply. But i have a concern that the result should be approved only if the status is "approve". Else it should be "rejected" if the status is "Reject" and even though the name are "XXX" or "YYY". In the above solution it gives the result as "approved" even if the status is "Reject". Pls let me know if i am not clear.

Saidinesh, Try this. =IF(AND([Status]="Approve",OR([Title]="XXX",[Title]="YYY")),"approved","rejected") Let us know if you were able to solve your problem or not. V

Saidinesh, Try this. =IF(AND([Status]="Approve",OR([Title]="XXX",[Title]="YYY")),"approved","rejected") Let us know if you were able to solve your problem or not. V

Saidinesh, Try this. =IF(AND(Status="Approve",OR(Title="XXX",Title="YYY")),"approved","rejected") Let us know if you are still having problem achieving the desired result.V

Hi, According to your description, I suggest that you should have a try this: IF(AND([Status]="Approve",OR([Name]="XXX",[Name]="YYY")),"approved","rejected") Best Regards David Hu