SOLVED

Excel Formula Help

Copper Contributor

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

4 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@KHicks85 

That'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 )

@KHicks85 

 

=IF(AND(L322="Northpoint",OR(C322={"PO Issued","Received"})),K322)

Thank you so much!

@KHicks85 

You are welcome

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@KHicks85 

That'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 )

View solution in original post