Results 16 to 16 of 16
Thread: Using If,And,Or statements
2014-08-12, 15:35 #16
- Join Date
- Mar 2011
- Thanked 1 Time in 1 Post
Try this one. The example is from the righmost 2 columns.
Also, I was curious why the two-year periods were segregated. If that's what's required, then I guess you live with it, but if the idea is to determine bonus eligibility based on two consecutive "4 or better" years, the attached spreadsheet will get you there. Also applied some conditional formatting to highlight the winners and losers (and non-players, by default!).