Jan 18 2022 01:17 PM
Hello! I need help trying to figure out a formula. What I need is basically, if L322=Northpoint, and C322=PO Issued or C322=Received, then cell=K322. Any other values in L322 or C322 would return False. All help is appreciated!!
Jan 18 2022 01:30 PM
SolutionThat's as you say
if L322=Northpoint, and C322=PO Issued or C322=Received, then cell=K322
=>
=IF( AND( L322="Northpoint", OR( C322="PO Issued", C322="Received" ) ), K322 )
Jan 18 2022 01:30 PM
Jan 18 2022 01:30 PM
SolutionThat's as you say
if L322=Northpoint, and C322=PO Issued or C322=Received, then cell=K322
=>
=IF( AND( L322="Northpoint", OR( C322="PO Issued", C322="Received" ) ), K322 )