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

# 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?

5 Replies

# Re: Formula required

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

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

# Re: Formula required

Thank you. It worked

# Re: Formula required

@E_D_D_Y As a variant:

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

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

# Re: Formula required

thanks. it worked.

# Re: Formula required

I have used a recent Excel 365 function

``= 2000 + TEXTAFTER(studentID,"/")``

It should return the entire column as a dynamic range.