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
Another question on Computers and Technology
Computers and Technology, 23.06.2019 18:00
Which is a possible benefit of having a good credit history? having a checking account low interest rate on a car loan high interest rate on a credit card offer bankruptcy
Answers: 1
Computers and Technology, 23.06.2019 23:30
The keyboard usually has six rows of keys. which of the following is not one of the key group categories? letter keys number keys control keys graphic keys
Answers: 1
Computers and Technology, 24.06.2019 01:30
Hazel has just finished adding pictures to her holiday newsletter. she decides to crop an image. what is cropping an image?
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
Mathematics, 26.12.2019 00:31
Advanced Placement (AP), 26.12.2019 00:31
Computers and Technology, 26.12.2019 00:31
English, 26.12.2019 00:31
English, 26.12.2019 00:31
Social Studies, 26.12.2019 00:31
History, 26.12.2019 00:31
Mathematics, 26.12.2019 00:31
