I use this formula to return the value in cell if the criteria is met but I would like to extend this to say that the value is also returned if cell J89 = ("C") i.e. either or I89 = W or J89 = C.

=IF(AND(A890,I89="w"),A89,"0")

Hope that makes sense