If statements using "AND" "OR"

[Bhavini]

I am trying to do an if statement that looks at two two cells and gives me a reference.

I have duplicate job numbers and in some cases one might be booked and one might be cancelled. I am trying to look at column a and determing if its a duplicate to the one above, If it si then I want to look at if it has a booked or cancelled status. This is what I tried.

=IF(AND(OR(A5=A4,W5="booked",W5="cancelled")),2)

Please help

[NBVC]

Try

=IF(A5=A4,IF(OR(W5="booked",W5="cancelled"),2,""),"")

This will check if A6=A4, if yes it will check if W5="Booked" or "Cancelled", if yes it will return a 2.. otherwise a blank is returned.

Not sure if that is the logic you intendend or not.

[wimfrits]

Is this what you mean?

IF(A5=A4,IF(W5="booked","duplicate:booked",IF(W5="cancelled","duplicate:cancelled","duplicate:other status")),"")

check if A5 = A4. If not; result = empty.
If A5 = A4, then check and show the latest status.