Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

Formula required

Copper Contributor

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?excel.PNG

5 Replies

@E_D_D_Y 

=NUMBERVALUE("20"&RIGHT(A2,LEN(A2)-FIND("/",A2)))

You can try this formula. What is the expected result of the check digit in S6?

year of enrolment.JPG

 

Thank you. It worked

@E_D_D_Y As a variant:

=--("20"&RIGHT(A2,2))

Same question with regard to "the check digit in S6".

thanks. it worked.

@E_D_D_Y 

I have used a recent Excel 365 function

= 2000 + TEXTAFTER(studentID,"/")

It should return the entire column as a dynamic range.