Hi,
I have a grading table which is attached.
I'm using a VLookup Formula at the moment and what I'm trying to do is the following:
* If there is an exact match, award the appropriate grade E.G. If score is '10' then 'Poor'
* If there is not an exact match, round up or down to nearest grade. E.G If score is '41' then 'Above Average'.
* If there's a split difference though, always round up. E.G. If the user gets 5 round up to 10 rather than 0.
* If the cell is blank or an invalid value is entered, have the cell default to the text "Not Graded". E.G. If text is entered, an invalid number like 101 is entered or nothing is entered this should be the defaultetc.
Tried to have a go in G5 but didn't work out. Thank you in advance. BTB
Bookmarks