Dear Excel Gurus...

I have a bunch of data that I need to divide into different categories (columns). Is there any way that I can create a formula where it would take into account that IF column A is equal to 1, 2, or 3 (for example), AND column B does NOT equal 10, I can get the value in column C?

For now I'm using: IF(OR(A1=1, A1=2, A1=3), C1, 0), but I'm not sure how to incorporate the part about column B in there.

Thank you!!