I want to create a calculated column that evaluates the conditions of 2 other columns to decide on a response.
Column A Column B Column C
So if Column A=aaa and if Column B=bbb then Column C should display 12345. I have several combinations I'll need to nest, which I think I can do if I can figure out the initial formula. Ideas?