Calculated Column with IF OR AND
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 !!!
May 10th, 2011 8:42pm

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.
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 9:56am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics