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 !!!

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.