i need assistance bwing able to create a formula in order to create a function that calculates the commision rate earned by each sales rep based on years of service.

Which function should i used in excel to solve this question? Use a function to populate the name of the sales rep associated with each sale. A B D E Sale Date Customer No. Customer Name Amount Sales Rep 2 01/02/21 43966 Fox Ava Inc $ 349,062.00 8 01/05/21 43977 Bambi Sandy Co $ 83,248.00 # 01/11/21 43961 Fun Size Tucker Co $ 114,770.00 5 01/14/21 43954 Diesel Olive Corp $ 121,819.00 5 01/14/21 43977 Bambi Sandy Co $ 444,933.00 01/15/21 43978 Cheeto Milo Co $ 34,051.00 3 01/17/21 43961 Fun Size Tucker Co $ 415,204.00 e 01/17/21 43977 Bambi Sandy Co $ 454,913.00 0 01/18/21 43959 Romeo Honey Corp $ 24,162.00 1 01/19/21 43977 Bambi Sandy Co $ 401,950.00 21 01/19/21 43966 Fox Ava Inc S 88.948.00 TU I: Which function should i used in excel to solve this question? Use a function to populate the name of the sales rep associated with each sale. A B D E Sale Date Customer No. Customer Name Amount Sales Rep 2 01/02/21 43966 Fox Ava Inc $ 349,062.00 8 01/05/21 43977 Bambi Sandy Co $ 83,248.00 # 01/11/21 43961 Fun Size Tucker Co $ 114,770.00 5 01/14/21 43954 Diesel Olive Corp $ 121,819.00 5 01/14/21 43977 Bambi Sandy Co $ 444,933.00 01/15/21 43978 Cheeto Milo Co $ 34,051.00 3 01/17/21 43961 Fun Size Tucker Co $ 415,204.00 e 01/17/21 43977 Bambi Sandy Co $ 454,913.00 0 01/18/21 43959 Romeo Honey Corp $ 24,162.00 1 01/19/21 43977 Bambi Sandy Co $ 401,950.00 21 01/19/21 43966 Fox Ava Inc S 88.948.00 TU