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, 22.06.2019 02:00
What is the process in which the software development team compiles information to determine the final product.
Answers: 3
question
Computers and Technology, 23.06.2019 12:40
Curriculum exam to process a resident's payment, you must click on onesite payments home page. from the a. reports b. my settings o c.transactions o d. rent tab
Answers: 1
question
Computers and Technology, 24.06.2019 18:20
Acommon algorithm for converting a decimal number to binary is to repeatedly divide the decimal number by 2 and save the remainder. this division is continued until the result is zero. then, each of the remainders that have been saved are used to construct the binary number.write a recursive java method that implements this algorithm.it will accept a value of int and return a string with the appropriate binary character representation of the decimal number.my code: public class lab16{public string converttobinary(int input){int a; if(input > 0){a = input % 2; return (converttobinary(input / 2) + "" +a); } return ""; } }
Answers: 1
question
Computers and Technology, 25.06.2019 08:20
Which of the following statements is true of offshore outsourcing? a. improved telecommunication systems have increased its attractiveness.b. the limited availability of the internet has reduced its effectiveness.c. reduced bandwidth has increased its efficiency to perform with low latency.d. the increased cost of communication has reduced its popularity.
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
Social Studies, 10.12.2020 01:40
question
History, 10.12.2020 01:40
question
Mathematics, 10.12.2020 01:40
question
Mathematics, 10.12.2020 01:40
question
Social Studies, 10.12.2020 01:40
question
History, 10.12.2020 01:40
question
Mathematics, 10.12.2020 01:40
question
Mathematics, 10.12.2020 01:40