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.5% . Change the value of VAT% to 12%, what is the Net Amount of Tablet PC? Format your answer to one decimal place.
Write the answer in the box.
Want instant access to all verified answers on moodle.polytechnic.bh?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!