Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A B C D 1 Subtotal Shipping Amount Total 2 1,449.75 1,522.24 3 1,659.90 1,659.90 4 454.65 477.38 Instruction : Based on the data above,
A | B | C | D |
1 | Subtotal | Shipping Amount | Total |
2 | 1,449.75 | 1,522.24 | |
3 | 1,659.90 | 1,659.90 | |
4 | 454.65 | 477.38 |
Instruction: Based on the data above, calculate the Shipping Amount for cell C2.
Criteria:
- There is No Shipping Charge for Subtotals of 1500 or more, Otherwise the Shipping Amount is 2% of the Subtotal (B:).
- Create your IF Function for cell C2:
- Click on the Submit Assignment button in the upper right corner.
- Write your IF function formula by typing in the Text Entry area.
- The calculated result is not necessary.
Your formula needs to work in an actual Excel workbook. Include all syntax elements such as = and ( ) signs.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started