Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!