Answered step by step
Verified Expert Solution
Question
1 Approved Answer
formula for a discount of 8% is applied to order more then 25 items Home Insert Draw Page Layout Formulas Data Review View Tell me
formula for a discount of 8% is applied to order more then 25 items Home Insert Draw Page Layout Formulas Data Review View Tell me % v Conditional Formatting Format as Table Cell Styles O Paste Font Alignment Number Cells Editing An D F2 4 x B c D E H K Discount Total Cost WON Amount 207 621 167 108 197 275 155 Directions 1. Calculate the Amount for each item in Column E using a formula 2 Use an IF/THEN statement to calculate the discount in Column F. A discount of 8% is applied to orders more than 25 items. 3. Add a forumla to calculate Total Cost in Column G (Amount - Discount) 4. In Row 26 sum up the dollar amounts in Columns E, F, and G. 1 Book Title Book "Star" unit Price tema Birthday Jokes Miguel 1295 16 Birthday Jam Session Angel 11.95 52 4 Happy New Year Honey Wally 13.95 12 5 The Hanukkah Story Bully 11.95 9 5 Christmas Songs keer 10.95 18 Thanksgiving Massage Harry 11.95 23 8 Happy Anniversary to You Kelly 12.95 12 9 Halloween Tales Keisy August 10.95 14 10 Halloween Tales Emilio lavez 10.95 34 11 Birthday lam Session Leo 11.5 18 12 Birthday Fun 4 Youl Laura Jones 10.95 21 13 Birthday Jokes Jm 12.95 19 14 Birthday Jokes Kyle 12.95 31 15 Thanksgiving Message Paul 13.95 33 16 Christmas Songs Lane Brody 10.95 16 17 Hoy Anniversary to You Gerry 12.95 51 18 Happy New Year, Honey Olan 1495 14 19 Birthday Fun 4 You Carol Willis 1095 21 20 Halloween Tales Norm Garcia 16 21 The Han Story Edda 11.95 22 22 Christmas Songs Peter Kline 8.5 13 23 Halloween Tales Leslie Miu 10.95 24 24 Thanksgiving Massage Lane 11.95 28 25 The Harry Frank 26 Totals - 27 20 29 30 31 32 33 34 35 36 153 372 207 230 246 401 460 175 660 209 230 159 263 111 26 335 142 6.349 9.95 +
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started