Forum Discussion

bbsin's avatar
bbsin
Iron Contributor
Aug 22, 2024

based on 2 cell how to auto populate text to another cell

 

hi 

 

I like to auto input WalkIn to cell D if cell A, B is empty  row 6

but also if cell B has ZOOM it will dispaly WalkIn  row 5 in cell D too

=IF($B5="ZOOM", "WalkIn","")

 

Thank you

 

Thank you

Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    Aug 22, 2024

    bbsin 

     

    This should do it (on row 6):

     

    =IF(OR(AND($A6="",$B6=""),$B6="ZOOM"), "WalkIn","")

     

     

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Aug 22, 2024

    bbsin 

     

    This should do it (on row 6):

     

    =IF(OR(AND($A6="",$B6=""),$B6="ZOOM"), "WalkIn","")

     

     

    • bbsin's avatar
      bbsin
      Iron Contributor
      Aug 22, 2024
      hi JKPieterse,

      This is great, Thank you

Resources