Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Column A Column B Column C Formula
1 2 5 =SUM(A2:C2)
5 3 10 =A3*C3+B3
2 2 4 =COUNTIF(A:C,2)
0 0 No =IF(and(A5=0,B5=0,C5="Yes"),1,0)
0 0 Yes =IF(and(A6=0,B6=0,C6="Yes"),1,0)
1 0 1 =IF(AND(A7=1,B7=0),"UPDATE",IF(AND(A7=0,B7=1),"CHECK","No Change"))
0 1 1 =IF(AND(A8=1,B8=0),"UPDATE",IF(AND(A8=0,B8=1),"CHECK","No Change"))
0 0 0 =IF(AND(A9=1,B9=0),"UPDATE",IF(AND(A9=0,B9=1),"CHECK","No Change"))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.