Assign names of your choice to the ranges A3:A27, B3:B27, C3:C27 and D3:D27. • With an IF and appropriate Text Functions, write a single formula in column E that creates usernames for students according to the rule: If a student has a first name and middle name, take the first letters of both names, and join them to the last four digits of their registration number. Else, if the student only has a first name, take the first two letters of the first name and join them to the last four digits of their registration number. Usernames should be in lowercase. For example: Rose Tanya Durant with number k0387 will have the username rt0387 and April Matthews with number k0125 will have the username ap0125. Formulas must use only range names and work for any new data typed into the cells
what will be the formula for this question?