Hi all.
I am a teacher and I know only a little of Excel.
I have made a set of sheets to automate scoring.
In one cell (and I will use cell values as an example), V3 it adds all the maximum possible scores. In V5 I have made a formula to add all the year's marks actually achieved. In V6 I have a formula that gives a percentage compared to V3, viz;=(V5/V3*100)
I want the next two cells to look at the percentage achieved and insert text, which will reflect what we need to enter into school reports. Please see attached images. I have marked the cells I want text into with 'HERE'.
In each cell there are options - the column 'Effort' needs excellent, good, satisfactory, developing, needs to improve, not assessed.
In Achievement column it needs the text to be well above, above level standard, below, well below and not assessed.
The text to be inserted needs to be triggered by the percentage cell result in V5.
so, if V5 was 40% - in 'Effort' it would return 'Developing' and in 'Achievement' it would return 'Level Standard' for example.[ATTACH=CONFIG]67454[/ATTACH][ATTACH=CONFIG]67455[/ATTACH]
Greatly appreciate any help.
Len Clark
[email]<snip>[/email]