Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Sector Accounting And Finance

Authors: Prof Stephen Sunday Sharang Ph.D.

1st Edition

979-8639273353

More Books

Students also viewed these Accounting questions

Question

Identify cultural barriers to communication.

Answered: 1 week ago