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 $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

Answer 1

Solution:-

Please use below formula to get above results:-