I am sure this is easy for most of you, but I am struggling. I would like to put 2 IF Functions in one cell.
I started with this and it works fine:
=IF(A12="X",1,0)
I would just like to add that IF B12 has an X, then it would equal 1 as well. Either A12 or B12 will have an X, never both...