Computers and Technology, 25.10.2021 09:20, rchapman414

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

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 18:00, deathfire5866

Determine whether the following careers would require training or college.

Answers: 1

continue

Computers and Technology, 23.06.2019 03:50, dondre54

Q-1 which of the following can exist as cloud-based it resources? a. physical serverb. virtual serverc. software programd. network device

Answers: 1

continue

Computers and Technology, 23.06.2019 05:00, bellad0124outlookcom

In cell b18, enter a formula to calculate the amount budgeted for meals. this amount is based on the daily meal allowance and the total travel days (# of nights+1).

Answers: 1

continue

Computers and Technology, 23.06.2019 09:30, jason9394

Facial expressions and gestures are examples of messages.

Answers: 3

continue

Do you know the correct answer?

Christina needs to calculate the shipping costs for each invoice. The company charges a flat rate sh...

Questions in other subjects:

History, 21.04.2020 19:10

Which statement about the U. S. blockade is true? There was no naval blockade. The naval blockade covered a larger area than the air patrol. O The air patro...

Mathematics, 21.04.2020 19:10

Which is equivalent to P(Z > 1.4)? Paz<1.4) 1-P(Z < 1.4) P(Z > -1.4)...

English, 21.04.2020 19:10

Why did Edward look for the noise by himself?...

Computers and Technology, 21.04.2020 19:10

PLEASE HELP Which of the following is considered a modern method of communication? Hieroglyphics Smoke signals Tablet Telegraphs...

Mathematics, 21.04.2020 19:10

1. Let či(t), 72(t),...,n(t) be n-vector functions defined on the interval (0,2). If the Wronskian W 51, 72,...,n(t) + 0 at t = 1 € (0,2), then Ei(t), 72(t),..., in(t) are linearly...

Social Studies, 21.04.2020 19:10

Ellen's husband was killed in an automobile accident two weeks ago. Since that time she has had repeated episodes of fleeting hallucinations and delusions. Her behavior has been ma...

Physics, 21.04.2020 19:10

Ldentify three features near our home that are examples of people changing land...

Geography, 21.04.2020 19:10

Match the terms to their definition. 1 . underground water sources aquifers 2 . a broad, triangular-shaped land area at the mouth of a river archipelago 3 . a group of islands clus...

Chemistry, 21.04.2020 19:10

3. A 0.600L sample of a 2.50M solution of potassium iodide (KI) contains what mass of KI? Do not include units. Round the the nearest whole number. * (5 Points) E...

English, 21.04.2020 19:10

What is arya’a problem...

Other tasks in the category: Computers and Technology More task