Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I NEED THE FORMULA FOR CELL F2 A discount of 8%is applied to order more then 25 items , if items are not more then

I NEED THE FORMULA FOR CELL "F2" A discount of 8%is applied to order more then 25 items , if items are not more then 25 it should give a output of zero !
image text in transcribed
Home Insert Draw Page Layout Formulas Data Review View Tell me X LB Geneva 10 ' 2 Wrap Text Number V Paste BIU y A Merge & Center $ v % ) 88 00 Conditional FC Formatting as F2 xfx A B C D E H J K Discount Total Cost Amount 207 621 167 108 197 Book Title Book "Star" Unit Price Items 2 Birthday Jokes Miguel 12.95 16 # Birthday Jam Session Angel 1195 52 4 Happy New Year, Honey Wally 13.95 12 5 The Hanukkah Story Bay 11.95 9 6 Christmas Songs Jake Beggs 10.95 18 7 Thanksging Message Hany 11.95 8 Happy Anniversary to Youl Kaly 12.95 12 9 Halloween Tales Kelly August 10.95 14 10 Haloween Tales Emojave 10.95 34 11 Birthday Jam Session Leo 115 18 12 thday Fun 4 You! Laura Jones 10.95 21 13 Birthday Jokes Jim 12.95 19 14 Berthday Jokes Kyle 12.95 31 15 Thanksgiving Massage 13.95 33 16 Christmas Songs Jane Brody 10.95 16 17 Hey Anniversary to Youl Jerry 1295 51 18 Happy New Year, Honey Olan 14 19 Birthday Fun 4 You Carol Wis 10.95 21 20 Haloween is Norm Garcia 9.95 16 25 The Man Story Edda 11.95 22 22 Christmas Songs Peter Kline 85 13 23 Halloween Tales Les M 1095 24 24 Thanksgiving Massage Lane 11.95 28 25 The Hanukkah tery 1295 11 26 Totals 27 28 29 30 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 275 153 153 372 207 230 246 401 460 175 660 209 230 159 263 111 263 335 142 6.349

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial & Managerial Accounting, The Managerial Chapters

Authors: Tracie Miller Nobles, Brenda Mattison

7th Edition

0136503616, 9780136503613

More Books

Students also viewed these Accounting questions

Question

=+6 Both cats and dogs are to be tested. Should you block? Explain.

Answered: 1 week ago