subject

Christina needs to calculate the shipping costs for each invoice. The company charges a flat rate shipping charge of $5. Shipping charges are waived for invoices of $100 or more. In cell H5, create a formula using the IF function and structured references to determine the shipping based on the following criteria:
a. If the value in the Amount column ([Amount]) is less than 100, the shipping charge is 5.
b. If not, the shipping charge is 0.
HELP ASAP PLEASE i keep using the formula =IF([Amount]<100,5,0) but it wont work right

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 18:00
What can a word user do with the customize ribbon dialog box? check all that apply. minimize the ribbon add a new tab to the ribbon remove a group from a tab add a group to a tab choose which styles appear choose which fonts appear choose tools to appear in a group
Answers: 1
question
Computers and Technology, 24.06.2019 09:50
Create a string list. 2. use console.readline() to collect values of firstname, lastname, street, city, state, zip, save them to list. 3. write a simple linq statement, call method uppercasewords() to change first letter to uppercase. 4. create a foreach statment to display the information. public static string uppercasewords(string value) { char[] array = value.tochararray(); if (array.length > = 1) { if (char.islower(array[0])) { array[0] = char.toupper(array[0]); } } for (int i = 1; i < array.length; i++) { if (array[i - 1] == ' ') { if (char.islower(array[i])) { array[i] = char.toupper(array[i]); } } } return new string(array);
Answers: 3
question
Computers and Technology, 24.06.2019 17:40
Create a file called favorite_foods, and list your favorite foods, entering five or six or more. press enter after each favorite food so it appears on its own line (make certain you also press enter after the final food item). after the file is created, add two more foods you like that are not on the list (press enter after the final food item). view the list of foods to make certain the two items you added appear at the end of the list
Answers: 2
question
Computers and Technology, 25.06.2019 08:10
Which of the following statements is false? a. package access is rarely used. b. use the access modifier package to give a method or variable package access. c. classes in the same source file are part of the same package. d. if a program uses multiple classes from the same package, these classes can access each other's package access members directly through references to objects of the appropriate classes, or in the case of static members, through the class name.
Answers: 1
You know the right answer?
Christina needs to calculate the shipping costs for each invoice. The company charges a flat rate sh...
Questions
question
Mathematics, 09.02.2021 18:50
question
Mathematics, 09.02.2021 18:50
question
Mathematics, 09.02.2021 18:50
question
Mathematics, 09.02.2021 18:50
question
Mathematics, 09.02.2021 18:50
question
Mathematics, 09.02.2021 18:50
question
Mathematics, 09.02.2021 18:50
question
Mathematics, 09.02.2021 18:50
question
Mathematics, 09.02.2021 18:50
Questions on the website: 13722363