Question

In the Sales Tax cell (cell H28), enter a formula that calculates the Sales Tax based on the following criteria: If the customer’s state (cell C12) is IL, then the sales tax will be 7.00 percent of the subtotal (cell H27). If the customer's state (cell C12) is NOT IL, the sales tax will be $0 (There is no sales tax for orders outside of IL). Hint: You will need to use an IF Function.

Name: in the sales tax cell cell h28 enter a formula that calculates the sales tax based on the following criteria if the customers state cell c12 is il then the sales tax will be 700 percent of t 91157
Uploaded: 2023-06-21T05:16:06-08:00
Duration: 5 min 25 s
Channel: Supreeta N
Description: in the sales tax cell cell h28 enter a formula that calculates the sales tax based on the following criteria if the customers state cell c12 is il then the sales tax will be 700 percent of t 91157

          In the Sales Tax cell (cell H28), enter a formula that calculates the Sales Tax based on the following criteria: If the customer’s state (cell C12) is IL, then the sales tax will be 7.00 percent of the subtotal (cell H27). If the customer's state (cell C12) is NOT IL, the sales tax will be $0 (There is no sales tax for orders outside of IL). Hint: You will need to use an IF Function.

Added by Angela M.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Supreeta N

06/21/2023

Step 1

Step 1: Identify the customer's state from cell C12. Show more…

Show all steps

Thanks for your feedback!

In the Sales Tax cell (cell H28), enter a formula that calculates the Sales Tax based on the following criteria: If the customer’s state (cell C12) is IL, then the sales tax will be 7.00 percent of the subtotal (cell H27). If the customer's state (cell C12) is NOT IL, the sales tax will be $0 (There is no sales tax for orders outside of IL). Hint: You will need to use an IF Function.