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.
This question generated 8 answers. To proceed to the answers, click here.
This thread is current as of December 13, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel