I am setting up a results spreadsheet and need this problem solved to create the result below.
A1 = 40
B1 = 50
A2 = 30
B2 = 20
I want if (A1+A2)>(B1+B2) to show "1" in cell C1, only if all the cells are filled, if any cells are not filled to show "0" in C1.