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

Other questions on the subject: Computers and Technology

image
Computers and Technology, 21.06.2019 21:30, karleebowling316
Asuccessful format string attack attempted to steal user account information by reading from unauthorized memory. answer the followings with proper explanation a)this attack will lead to violation of which security policies?
Answers: 2
image
Computers and Technology, 23.06.2019 00:30, alex7078
Quick pl which one of the following is considered a peripheral? a software b mouse c usb connector d motherboard
Answers: 1
image
Computers and Technology, 23.06.2019 00:40, QueenKy6050
Consider the following statements: struct nametype{string first; string last; }; struct coursetype{string name; int callnum; int credits; char grade; }; struct studenttype{nametype name; double gpa; coursetype course; }; studenttype student; studenttype classlist[100]; coursetype course; nametype name; mark the following statements as valid or invalid. if a statement is invalid, explain why. a.) student. course. callnum = "csc230"; b.) cin > > student. name; c.) classlist[0] = name; d.) classlist[1].gpa = 3.45; e.) name = classlist[15].name; f.) student. name = name; g.) cout < < classlist[10] < < endl; h.) for (int j = 0; j < 100; j++)classlist[j].name = name; i.) classlist. course. credits = 3; j.) course = studenttype. course;
Answers: 1
image
Computers and Technology, 24.06.2019 21:30, zlyzoh
Write an algorithm to check if a number is even or odd and show with flow chart step by step
Answers: 2
You know the right answer?
Christina needs to calculate the shipping costs for each invoice. The company charges a flat rate sh...

Questions in other subjects: