Formula required

Question

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?

oliverscheurich · Answer

E_D_D_Y&nbsp;=NUMBERVALUE("20"&amp;RIGHT(A2,LEN(A2)-FIND("/",A2)))You can try this formula. What is the expected result of the check digit in S6?&nbsp;

e_d_d_y · Answer

Thank you. It worked

riny_van_eekelen · Answer

E_D_D_Y&nbsp;As a variant:=--("20"&amp;RIGHT(A2,2))Same question with regard to "the check digit in S6".

e_d_d_y · Answer

thanks. it worked.

peterbartholomew1 · Answer

E_D_D_Y&nbsp;I have used a recent Excel 365 function= 2000 + TEXTAFTER(studentID,"/")It should return the entire column as a dynamic range.

Forum Discussion

Formula required

Share

Resources