marcsalazar
New Member
- Joined
- Dec 13, 2014
- Messages
- 4
Example:
=IF(D5>39,"Y"," ")or=IF(G5,L5,Q5:Q>9,"Y"," ")
I am trying to get the cell to display a "Y" if one of two conditions are met
Don't know if I can use the term "OR" where I have it, but it explains what I need to do.
The first condition is if a single cell has a number greater than 39
The second condition is if one of multiple cells contains a number greater than 9
I am a High School Athletic Director trying to establish a spreadsheet to track students participation points for earning their letter. Letters are earned through total points or making a varsity team.
=IF(D5>39,"Y"," ")or=IF(G5,L5,Q5:Q>9,"Y"," ")
I am trying to get the cell to display a "Y" if one of two conditions are met
Don't know if I can use the term "OR" where I have it, but it explains what I need to do.
The first condition is if a single cell has a number greater than 39
The second condition is if one of multiple cells contains a number greater than 9
I am a High School Athletic Director trying to establish a spreadsheet to track students participation points for earning their letter. Letters are earned through total points or making a varsity team.