Forum Discussion
Formula required
The last two digits of the student number indicate the year the student enrolled. In F4 create a formula that will put "20" followed by the last two digits of the Student ID, e.g. 2015. Copy the formula down for all the other students. What is the value of the check digit in S6?
=NUMBERVALUE("20"&RIGHT(A2,LEN(A2)-FIND("/",A2)))You can try this formula. What is the expected result of the check digit in S6?
- Thank you. It worked
- thanks. it worked.
I have used a recent Excel 365 function
= 2000 + TEXTAFTER(studentID,"/")It should return the entire column as a dynamic range.
