![zandariouslee](/avatars/34823.jpg)
zandariouslee
12.10.2020 •
Computers and Technology
Input the total price of items purchased in cell F14 by referencing the appropriate cell in the model inputs. 3 8 Calculate the Loyalty Discount % in cell F16. Notice that the discount rates depend both on the loyalty status of the customer (gold or silver) and the total price of the items purchased (cell F14). Construct your formula so that it will correctly calculate the loyalty percentage regardless of the Loyalty Status and Total Price of Items in the Model Inputs. 4 3 Calculate the Loyalty Discount $ in cell F17. The loyalty discount $ is the total price of the items purchased (cell F14) times the loyalty discount percent (cell F16). 5 3 Calculate the Discounted Subtotal in cell F19. The discounted subtotal is the difference between the total price of the items purchased (cell F14) and the loyalty discount $ (cell F17). 6 3 Calculate the Sales Tax for the transaction in cell F20. T
Solved
Show answers
More tips
- A Auto and Moto Which alarm system to choose?...
- C Computers and Internet Porn Banner: What It Is and How to Get Rid Of It?...
- F Food and Cooking How many stages of coffee roasting are there?...
- F Food and Cooking From Latte to Espresso: Which Coffee Drink is the Most Popular on Earth?...
- F Food and Cooking Experts Name Top 5 Healthiest Teas...
- C Computers and Internet Google Search Tips and Tricks: Everything You Need to Know...
- H Health and Medicine Discover the Hidden Principles and Real Results of the Japanese Diet...
- H Health and Medicine Liver Cleansing - Rejuvenation for the Body?...
- S Style and Beauty Is Photoepilation the Solution to Unwanted Hair Forever?...
- S Style and Beauty Unbelievable Hairstyles for Long Hair - 2021 Trends...
Answers on questions: Computers and Technology
- M Mathematics The tables show the cost of different numbers of t-shirts ordered at two different stores, Store P and Store Q: Store P Number Cost of T-shirts (in $) 3 $18 6 $36 9 $54 Store...
- E English dancer by vickie sears what point do you think the narrator is making when she says ay the end of the story that molly and greybull and clarissa are both the same age...
- M Mathematics Given f(x) = 2x² + 4x - 7, what is f(3)? Help fast please...
- M Mathematics Solve for f. –9(–2f − 8) = –6f f =...
Ответ:
1: Records
2: tables