Hi everyone can someone please help me with what I believe is a minor problem (at least I hope it is!!) I have a spreadsheet that calculates verious total values. What I want to achieve is if these values are between 2.5 and 4.4 to append "PASS" , if the value is between 4.5 and 6.4 to append "MERIT" and if the value is 6.5 and over "DISTINCTION in the adjacent cell. Any help would be greally appreciated.

Thanks in anticipation

Integrity