Conditional Logic for Determining Total Price for Shipment

Scenario 1: Determining Total Price for USA Shipments

Instructions: For each of the scenarios below: 1) Write an IF/THEN/ELSE pseudocode statement to help you specify the requirements of the conditional logic 2) Convert that statement into an Excel formula The syntax of the IF function in Excel is =IF(Logical Test, [Value if True], [Value if False]) Pseudocode consists of using regular English to describe the various parts of your program. Consider the example of going to the cinema to see Star Wars. First you would check if the movie is showing. If it is, you then you will see that movie. If not, then you will check to see if there is a Star Trek movie showing. If it is, go and see that movie. Otherwise, go home. You could write this scenario in pseudocode as follows: IF Star Wars is showing THEN Go and see Star Wars ELSE IF Star Trek is showing THEN Go and see Star Trek ELSE Go home Keep in mind the following rules when constructing your pseudocode: Each nested IF statement should be indented in your pseudocode  Each IF statement should have a THEN branch and an ELSE branch which at as the (do this if TRUE and do this if FALSE, respectively) The first two scenarios give you a flowchart to help you picture the situation.

Scenario 1. Determine the Total Price (Column F). For an item that is shipped to the USA, there will be a 5% surcharge on the total price (Quantity  UnitPrice). For all other countries there will not be a surcharge.

Scenario 2. Determine the Total Price (Column D). For an item that is shipped to the USA, there will be a 5% surcharge on the total price (Quantity  UnitPrice). For items shipped to Mexico there will be a 6% surcharge. For all other countries there will not be a surcharge