Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored 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
International Accounting
Authors: Frederick D. Choi, Gary K. Meek
7th Edition
978-0136111474, 0136111475
