How do I make cell A3 equal 4 if cells A1 and A2 are the same?
For example if cell A1 and A2 have a X in it, then cell A3 =4
or if cell A1 and A2 are blank then cell A3 =4
As long as the cells match, cell A3=4
If cells do not match then cell A3 =0