How to combine an IF/AND and OVER function

[Jane K]

I have a table and trying to create a calculated column titled below as [Calculate Formula for Flag]. I would like to be able to write a formula that states:

If the customer orders:

Apple/Orange, then flag the entire account "Yes"

Box, then flag the entire account "Yes"

I have multiple other conditions. Basically, is there a way to combined multiple IF/AND statements OVER the Account ID Thanks!

 

 

 

Customer ID

Customer Name

Order Code

Order Product

[Calculate Formula for Flag]

 

 

193203

Mike

222

Apple

Yes

 

 

193203

Mike

555

Orange

Yes

 

 

193203

Mike

333

Yarn

Yes

 

 

518482

Jane

222

Apple

No

 

 

518482

Jane

222

Apple

No

 

 

518482

Jane

333

Yarn

No

 

 

748254

Tim

666

Box

Yes

 

 

748254

Tim

222

Apple

Yes