Search code examples
if-statementgoogle-sheetscountauto-updatenested-if

Auto input value when multiple conditions are fulfilled

i am looking for formula, which can auto detect value in column A & B inputted manually and auto update value in column C once condition is triggered. Thank you. the example excel: https://docs.google.com/spreadsheets/d/1FJB6kSUnWnmxJ7VB0lAO_K88eWg8aZAaLN2KPx0uj14/edit?usp=sharing

Solution

  • try:

    =INDEX(IF(A2:A="",,IF((A2:A=1)*(B2:B=1), 1, 0)))

    enter image description here