I need the formulas for each column form H to O by using this function: IF(), LOWER(), UPPER(), FIND(), ISERROR(), CONCATENATE(), LEFT(), MID(), etc.

iv. Column H (Category code): Derive 4-letter category codes from the respective Sport categories in column B. If the name of the sport consists of one word, the code should be formed from the first four letters of that word. If the name of the sport consists of more than one word, form its code from the first three letters of the first word and the first letter of the second word. Category codes Page 1 of 5 should be in uppercase letters. For example, the code for Hiking should be HIKI, and that for Speed Skating (if added later) should be SPES. Column I (Item code): Item codes should also be 4-letter codes derived from item names in column C. They should also be formatted like category codes but in lower case. For example, Mouthguard should have the code mout, and Abdominal Guard should be encoded as abdg. It is acceptable if formulas written return 3-letter item codes for items with 3-letter words. Column J (Stock code): Stock codes should be a concatenation of I05 (column A), category codes (column H), and item codes (column I), with underscores between them. For example, stock code for the first item should be 5197_GOLF_bag. Column K (Stay): The Stay for each item should show the number of days that items have been in stock. They should be derived by calculating the number of days from the date of delivery in columns D, E, F to the present day. Use the Excel functions Days(), TODAYO, and DATE() to do the calculations. you'll create). A B C D E F G H K M N O ID Sport Item Day Month Year Price Category code Item code Stock Code Stay Discount Adjusted price Tax Sale Price 2 5107 Golf Bag 28 11 2020 $199.99 GOLF bag 5107_GOLF_bag 76 20% $159.99 $20.80 $180.79 3 4460 Golf Cart 12 12 2020 $1,899.00 GOLF cart 4460_GOLF_cart 62 20% $1,519.20 $197.50 $1, 716.70 5846 Golf Shoe 12 2 2021 $89.99 GOLF shoe 5846_GOLF_shoe 0 0% $89.99 $11.70 $101.69 5 9922 Golf Balls 21 11 2020 $29.99 GOLF ball 9922_GOLF_ball 83 20% $23.99 $3.12 $27.11 6 7793 Golf Glove 12 2 2021 $47.85 GOLF glov 7793_GOLF_glov 0 0% $47.85 $6.22 $54.07 7 9819 Golf GPS Watch 6 2 2021 $350.97 GOLF gpsw 9819_GOLF_gpsw 6 0% $350.97 $45.63 $396.60 8 3111 Golf Bottom 30 1 2021 $59.99 GOLF bott 3111_GOLF_bott 13 0% $59.99 $7.80 $67.79 9 5753 Golf Head covers 8 18 2020 $28.89 GOLF heac 5753_GOLF_heac 188 20% $23.11 $3.00 $26.12 10 1462 Golf Outerwear 9 1 2021 $100.00 GOLF oute 1462_GOLF_oute 34 10% $90.00 $11.70 $101.70 11 7805 Golf Top 23 2021 $28.99 GOLF top 7805_GOLF_top 20 0% $28.99 $3.77 $32.76 12 6411 Tenni Racquet 30 1 2021 $89.99 TENN raca 6411_TENN_racq 13 0% $89.99 $11.70 $101.69 13 8705 Tennis Shoe 10 10 2020 $99.99 TENN shoe 8705_TENN_shoe 125 20% $79.99 $10.40 $90.39 14 9882 Tennis Bag 21 11 2020 $79.99 TENN bag 9882_TENN_bag 83 20% $63.99 $8.32 $72.31 15 9353 Tennis String 15 8 2020 $19.99 TENN stri 9353_TENN_stri 181 20% $15.99 $2.08 $18.07 16 4679 Tennis Balls 17 10 2020 $17.99 TENN ball 4679_TENN_ball 118 20% $14.39 $1.87 $16.26 17 1003 Tennis Top 12 12 2021 $49.99 TENN top 1003_TENN_top 0% $49.99 $6.50 $56.49 18 5859 Tennis Polo 31 10 2020 $89.97 TENN polo 5859_TENN_polo 104 20% $71.98 $9.36 $81.33 19 2969 Tennis Short 16 1 2021 $55.99 TENN shor 2969_TENN_shor 27 0% $55.99 $7.28 $63.27calculations. v. Column L (Discount): Percentage discounts should be applied to various items according to their Stay in column K. Items that have been in stock for up to 30 days should have no (0%) discount. Items that have been in stock for over 30 and up to 60 days should have a 10% discount, while those that have stayed over 60 days should be given discounts of 20%. Use logic |F() function. vi. Column M [Adjusted price): Calculate the price of all items after the application of the discount in column L. It should be Price Discount * Price. vii. Column N (Tax): Sales tax on all items should be 13% of adjusted prices in column M. viii. Column 0 (Sale price): Add an item's adjusted price to the tax to obtain its sale price