Forum Discussion

E_D_D_Y's avatar
E_D_D_Y
Copper Contributor
Jan 29, 2023

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 form...
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor

E_D_D_Y As a variant:

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

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

E_D_D_Y's avatar
E_D_D_Y
Copper Contributor
Jan 29, 2023
thanks. it worked.

Resources