Crowdly
Add to Chrome
In Items sheet, use if function for the value of Discount% in cell C3 to che...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
In Items sheet, use if function for the value of Discount% in cell C3 to check the value of VAT% in C4. If VAT% is greater than 10%, then the Discount% will be 15%; otherwise, the Discount% will be 5% . Change the value of VAT% to 10%, what is the Net Amount of the Hard Disk Drive? Format your answer to 3 decimal places.
✅
❌
❌
❌