can you help me please with 10. can you show your formulas plz

000) and then a grand total of all items for all rooms. M Because larger jobs have certain economies.of scale in setup and cleanup, a discount is gien based on these estimated values to jobs based on their total size. Just below the primer, first coat, and Create a row be grand total, determine the total discounted price of the job based on the following: If the total cost of the painting job is less than $800, then there is no discount. if the total cost of the painting job is at least $800 but less than $2,000, then a 5% discount will be given (discount is calculated based on the grand total cost for all items and all rooms). If the total cost of the painting job is at least $2,000 but less than $5,000, then a 10% discount will be given. If the total cost of the painting job is $5,000 or more, then a 15% discount will be given. = Paste 40 BIU > a. Av 00 8 O $ % ) Format as Table Cell Styles 3 Delete Editing Format K13 X fe Le B F G H D E NT Painting & Sons- Calculators L M N O 1 30 2 IS 8 Length in With in 3 Room Feet Feet 4 Great Room 30 5 Bedroom 1 18 6 Bedroom 2 14 7 Bath 8 8 Total 9 Total Discounted Price: m 10 Square Feet (SF) of Height in Wall/Ceillin Wall Feet 8 Condition 14 12 1476 11 8 662 12 8 584 6 8 272 New Color Lighter 3 FALSE 1 FALSE 1 FALSE 2 TRUE Paint Quality Premium Superior Economy Premium First Coat Second Coat Paint Wall Repair Painting Painting Quality & Priming Cost Cost Adjustment Total Cost $738,00 $ 1,254.60 $ 664.20 $ 369.00 $ 3,025.80 430.30 0 0 $ 430.30 379.60 0 -87.6 $ 292.00 190.40 136 68 $ 394.40 $ 738.00 $ 2,254.90 $ 800.20 $ 349.40 $ 4.142.50 Low Price? FALSE FALSE TRUE FALSE 12 eft 13 14 15 ave 16 17 18 19 20 21 22 23 24 25 26 27 28