How to make symbol show up while dependent on multiple conditions

[Gaby_222]

As you can see in the photo, there are multiple marks for each student. I need to create a column at column U where, if you receive less than 20% in attendance, less than 50% in participation, less than 50% in final exam, or less than 50% in either of the two top papers, the cell in column U will = *. Otherwise, the column will remain blank. I'm sure it is a pretty easy formula, I just don't really know where to start. Thanks. **The complicated part may be the part where you only get a * if you have received less than 50% in either of your top two papers, not any of the papers.

 

[David Evans]

As you can see in the photo, there are multiple marks for each student. I need to create a column at column U where,
if you receive less than 20% in attendance, less than 50% in participation, less than 50% in final exam, - I take it these are additive conditions? i.e. <20% AND <50% AND < 50%
or less than 50% in either of the two top papers, - If the MIN score in the top two papers is < 50%


the cell in column U will = *. Otherwise, the column will remain blank. I'm sure it is a pretty easy formula, I just don't really know where to start. Thanks. **The complicated part may be the part where you only get a * if you have received less than 50% in either of your top two papers, not any of the papers.

View attachment 33553

Attach a sample file - it will be easier to write the formulas if you do so. It's a fairly straightforward request, made easier if we don't have to re-create a worksheet

 

[Hui]

I am unsure which column is which based on your photo, but the formula will be something like:
=IF(OR(AND(G2<20%,I2<50%,K2<50%),OR(P2<50%,R2<50%)),"*","")