Column C, insert an IF function by typing the following directly into the Formula Bar IF( Cost 15000 Cost 0 2,0) to calculate a 20 discount of jewelry that costs greater than $15,000 Jewelry Cost Discount Alexandrite Bracelet 2000 Diamond Bracelet 15000 Emerald Bracelet 6000 Moonstone Bracelet 1000 Opal Bracelet 7000 Ruby Bracelet 20000 Sapphire Bracelet 17000 Diamond Earrings 10500 Emerald Earrings 4750 Opal Earrings 6500 Sapphire Earrings 8950 Alexandrite Necklace 3500 Diamond Necklace 35000 Emerald Necklace 10500 Ruby Necklace 24500 Sapphire Necklace 20500 Alexandrite Ring 5500 Diamond Ring 17500 Emerald Ring 7000 Moonstone Ring 2500 Opal Ring 5500 Ruby Ring 17700 Sapphire Ring 10700

The Answer is in the image, click to view ...

Question: Column C, insert an IF function by typing the following directly into the Formula Bar:IF([Cost]>15000[Cost]*0.2,0) to calculate a 20%discount of jewelry that costs greater than

Column C, insert an IF function by typing the following directly into the Formula Bar:IF([Cost]>15000[Cost]*0.2,0) to calculate a 20%discount of jewelry that costs greater than $15,000.

Jewelry	Cost	Discount
Alexandrite Bracelet	2000
Diamond Bracelet	15000
Emerald Bracelet	6000
Moonstone Bracelet	1000
Opal Bracelet	7000
Ruby Bracelet	20000
Sapphire Bracelet	17000
Diamond Earrings	10500
Emerald Earrings	4750
Opal Earrings	6500
Sapphire Earrings	8950
Alexandrite Necklace	3500
Diamond Necklace	35000
Emerald Necklace	10500
Ruby Necklace	24500
Sapphire Necklace	20500
Alexandrite Ring	5500
Diamond Ring	17500
Emerald Ring	7000
Moonstone Ring	2500
Opal Ring	5500
Ruby Ring	17700
Sapphire Ring	10700

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

123please help me with this Winter 1, 2013 7/22/2012 Chapter 4. Ch 04 P35 Build a Model Except for charts and answers that must be written, only Excel formulas that use cell references or functions...

I have completed (a) through (e) on this assignment.. I need assistance completing f. Below is the instructions for the assignment, my complete excel data workbook and the excel 3-D column chart....

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Briefly discuss the cost-volume-profit analysis model and how it is used. Use the attached PDF. APA Citation. 300 words. REVISED PAGES 3 Chapter Three 1 Fundamentals of Cost-Volume-Prot Analysis...

See page 129- 137 on attachment for more details there are five steps to the project. Step 1: Create the loan amortization schedule for the property. Step 2: Create the depreciation schedule. Step 3:...

Deposit Rules for Glo-Brite Paint Company The FICA taxes and FIT taxes must be deposited on or before the 15th of the month following the month in w Federal taxes were withheld. Since Glo-Brite is a...

Which Ratio protects the Creditors? Lower Debt-Equity Ratio Liquidity Assets Higher Inventory Ratio Return on Investment Ratio

A 4-month European call option on a stock (with dividend) is currently selling for RM5. The price of the stock is RM64 and the strike price is RM60. The risk-free interest rate is 12% p.a. A dividend...

A firm can have a substantive competitive advantage even if the firm's stock price has been falling slowly over the last year. Group of answer choices True False

Ethics.Technology. A health spa used the term micro color in marketing campaigns to refer to permanent cosmetic makeup. A beauty supply company claimed the right to the term and said it was...

Ethics. Technology. Peter Drucker states that there is no such thing as Business Ethics, there is only ethics.Collaborate with another classmate to write a reaction paragraph to this statement....

Ethics. Technology. Evaluate this statement using the Texas Instruments Ethics Quick Test and the Code of Conduct from Figure 3.5: It is better to steal from the stockholders of a company than the...