need solution to step 4 only (data table 1 and data table 2) you must use formul

need solution to step 4 only (data table 1 and data table 2)
you must use formulas to get the result. Dont input values only.
I have attached example so that you can get to know what formulas must have used
Post bid only if you can handle it
i will provide updated excel after selecting the tutor