Register
Log In
Unanswered
Home
New Member
August 10, 2017
Offline
Hi
How do I create a formula that matches this table?
| Performance Tier | Pre-Test Score (Score prior to interval of instruction) | Growth Target (Add to Score) | |
| Tier A | >=0 | <=13 | 5 |
| Tier B | >=14 | <=29 | 7 |
| Tier C | >=30 | <=47 | 11 |
| Tier D | >=48 | <=65 | 9 |
| Tier E | >=66 | <=81 | 7 |
| Tier F | >=82 | <=94 | 5 |
I am able to create an If And formula for tier A; however, once I instruct it to add 5 I am not able to add any more tier criterias.
See Answer
Dashboards
June 25, 2016
Offline
Hi Rona
I would normally use a VLOOKUP in a situation like this.
Since you wanted an IF formula, I have attached a sample containing both VLOOKUP and IF formulas.
Here I am making an assumption that the minimum Tier A pre-test score is 0 and Tier F pre-test score is 82 and above (no maximum).
Hope this helps.
Sunny
Answers Post
Most Users Ever Online: 57
Currently Online:
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
