What is the Excel formula used in cell C2 to produce the required results

What is the Excel formula used in cell C2 to produce the required results?

What is the Excel formula used in cell C2 to produce the required results?