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 or equal to 10%, then the Discount% will be 10%; otherwise, the Discount% will be 6.5% . Change the value of VAT% to 15%, what is the Net Amount of Pen Tablet? Format your answer to no decimal places.
Write the answer in the box.
❌
✅
❌
❌
❌