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 ...
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