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

Answer 1

its got to be B!!! correct me if i am wrong!

Answer 2

Let's use python

[tex]\tt Amount=input("Enter \: amount")[/tex]

[tex]\tt if \:Amount<100:[/tex]

[tex]\tt \quad Ship==5[/tex]

[tex]\tt else:[/tex]

[tex]\tt\quad ship==0[/tex]


Related Questions

When it's unlikely that your data will change, what's the best option for pasting a chart

Answers

the answer is embed workbook

When it's unlikely that your data will change, what's the best option for pasting a chart embed workbook.

What is embed workbook?

Right-click the workbook on OneDrive and select Embed. Select Customize how this embedded worksheet will appear to others after selecting Generate. Click what you want to display in your blog in the What to show box. Show a chart, a named range, a pivot table, or a table, or display the whole workbook.

Click Object under the Text group on the Insert tab. On the Create from File tab, click. Select the desired file by clicking Browse and then choosing it. Select the Display as icon check box if you wish to add an icon to the spreadsheet rather than display the contents of the file.

In Excel, embedding often refers to inserting an object made in another program (such as Word, PDF, etc.). The procedure is called embedding.

Thus, embed workbook.

For more information about embed workbook, click here:

https://brainly.com/question/14271749

#SPJ5

We perform the following assignment commands: x:=1; y:=9; z:=x+y; z:=z*y; The result is

Answers

Answer:

"z" in z=x+y is 10. The first "z" in z=z*y equals 90.

Explanation:

Let's start with the first equation, z=x+y. Since we have our given values, all we have to do is add them. If "x" is 1 and "y" is 9, adding 1+9 gives us 10.

Now for the second equation, z=z*y. Since we have both values on the right hand side of the equation, we can already multiply to get our answer. The second "z" in the equation is the answer of "z" in the first equation, which is 10. Since "y" equals 9, multiplying 10 by 9 yields us 90.

Hope this helps buddy!

Order the steps for sharing a contacts folder in Outlook 2016

Answers

Answer:

Enter the Contacts view-Select folder in the navigation pane-Click Share Contacts-Fill the To: field with a recipient's address-Click Send.

Explanation:

Got it right on Edge  

Outlook is a management application that includes personal information.  The first step in sharing the contact folder includes entering the contact view.

What is contact sharing?

Outlook is the web platform that contains the personal information of the client and also, the messages, contact cards, calendars, and webmails. etc.

To share contact the contact view should be opened and then the folder should be selected in the navigation pane. The button for sharing contacts should be selected.

In the share contact pop-up, fill out the field to whom the contact is to be shared with their address. After entering the receiver's name and address click the send button to share the contact card.

Learn more about Outlook here:

https://brainly.com/question/19026125

#SPJ2

RAM is temporary memory?​

Answers

Answer:

No

Explanation:

Ram isn't temporary memory

Answer:

RAM is both used for temporary storage, and from a technical perspective it is only capable of temporary storage. The hard drive is capable of storing information after the computer turns off, but RAM is not. Once your computer turns off, any data that was in your RAM sticks is lost.

Explanation:

write a boolean expression that is true if s references the string end.

Answers

Boolean expressions are those expressions whose value can only be true or false.

The required boolean expression is: s == "end"  

From the question, we have the following highlights

The string variable is sThe string value is "end"

For the boolean expression to be true, then we need a comparison operator.

For this purpose, we make use of the == operator

Hence, the required boolean expression is: s == "end"  

Read more about boolean expressions at:

https://brainly.com/question/16843003

when faxing sensitive compartmented information what actions should you take

Answers

Sensitive Compartmented information are highly classified documents in which it's information are meant to be kept extremely secure. Hence, when faxing sensitive such documents, it should be encrypted.

Due to the volatility of sensitive Compartmented files, as most of them has to do with issues of national security, it's content are extremely precious and are meant to be kept safe.

Hence, when the need to fax these documents are required, they should be encrypted such that only those with the necessary security clearance have the decryption keys.

Therefore, the SCIF should be encrypted when faxed.

Learn more :https://brainly.com/question/25236672

I NEED HELP W/ BINARY NUMBERS ‼️⚠️‼️⚠️‼️⚠️‼️ DUE IN 15 MINUTES

Answers

1.

Binary: 01001

Decimal: 1 + 8 = 9

2.

Binary: 00000

Decimal: 0

Hope it helps

Answer:

1- the binary number is 01001

and the decimal number is 9

2-the binary number is 00000 (this is zeros)

-8irwqe4srxtfvgybuhjjbhvgfgvuybi

Answers

Answer:

I dont understand the question?

Explanation:

máy tính coá j vui giải thích choa tui biết đi

Answers

Answer:

sorry didn't know this language

Maya and Jay share $72 in the ratio 7 : 5. How much does Maya receive?

Answers

Answer:

42

Explanation:

72/12 = 6

6*7 = 42

what does it mean that the right mouse button is context-sensitive?

Answers

Answer:

The menu items available will differ depending on the context of what you are right-clicking . You would like to add some frequently used buttons to the Quick Access Toolbar. ...

Explanation:

It means that the mouse has  used menu commands that are used in terms of  situation when a person clicked the right mouse button.

What is  context-sensitive menus about?

A context-sensitive menu is one that often show up when clicking the right mouse button.

Note that A context-sensitive menu is one that only show the lists that are often used menu commands that are applicable to the scenario when a person clicked the right mouse button.

Learn more about mouse from

https://brainly.com/question/11262969

#SPJ2

Which of the following is an example of Boolean data?a) 12b) "Hello"c) TRUEd) 12 + 3

Answers

Answer:

C. True

Explanation:

a boolean is an expression that evaluated either true or false.

what should you do if you want word to apply a coordinated set of styles to ensure there is consistent formatting across the entire document?

Answers

Answer:

I'm pretty sure you can right click on a style and add it to a preset, if that's what you're asking.

Explanation:

Area Triangolo Rettangolo in c++

Scrivere un programma in C per il calcolo dell'area di un triangolo rettangolo, si richiede codice in c.
Dati di input: cateto1 e cateto2
Output: Area del Triangolo

Answers

Answer:

#include <iostream>

using namespace std;

void askCat(int &cateto1, int &cateto2);

int AreaRett(int cateto1, int cateto2, int &area);

void stampaRisultato(int area);

int main()

{

  int cateto1, cateto2, area;

  askCat(cateto1, cateto2);

  area = AreaRett(cateto1, cateto2,area);

  stampaRisultato(area);

}

void askCat(int &cateto1, int &cateto2)

{

 cout << "Inserisci lunghezza cateto1: ";

 cin >> cateto1;

 cout << "Inserisci lunghezza cateto2: ";

 cin >> cateto2;

}

int AreaRett(int cateto1, int cateto2, int &area)

{

 area = (cateto1*cateto2)/2;

 return area;

}

void stampaRisultato(int area)

{

 cout << "L'area del triangolo rettangolo e': " << area << endl;

}

( BRANLIEST)
Compare different types of (monitors). Mention advantages and disadvantages of each types.
IF ANYONE ANSWER IT I WILL GIVE **BRAINLIEST**

Answers

Answer:

A monitor is an electronic output device that is also known as a video display terminal (VDT) or a video display unit (VDU). It is used to display images, text, video, and graphics information generated by a connected computer via a computer's video card. Although it is almost like a TV, its resolution is much higher than a TV. The first computer monitor was introduced on 1 March 1973, which was part of the Xerox Alto computer system.

Older monitors were built by using a fluorescent screen and Cathode Ray Tube (CRT), which made them heavy and large in size and thus causing them to cover more space on the desk. Nowadays, all monitors are made up by using flat-panel display technology, commonly backlit with LEDs. These modern monitors take less space on the desk as compared to older CRT displays.

Answer:

I think answer is

Explanation:

Type of monitor

I.Touch screen monitor

II.LED Monitor

III.DLE Monitor

Advantage

i.Energy Consumption

Ii.Multipule Screen

Disadvantages

i.Screen Flicker

radiation

Edhesive 1.6 code practice: question 2

Answers

Answer:

Explanation:

?

the portion of the web that general search engines often fail to find is referred to as the:

Answers

Answer:

deep web

Explanation:

a person who uses computers to gain unauthorized access to data.

Answers

Answer:

Hacker

Explanation:

They break password codes to get access to unauthorized data.

Answer:

a hacker

Explanation:

why is computer called an information processing device ?​

Answers

Since, the computer accepts raw data as input and converts into information by means of data processing, it is called information processing machine (IPM).

Computer is called information processing machine because it gives you meaningful information after processing raw data......

12 / 4 * 3 div 2 tin học

Answers

Answer:

9/2 is the answers for the question

Explanation:

please mark me as brainlest

How do I fix my model O? I spilled water on it and the LED is working, but the mouse itself isn't responding to clicks or movement. it happened when I wanted to clean my model O I looked up a vid and I saw someone spilling water on it and saying it works completely fine, I need urgent help I'm begging you guys! the Lights work but u see the dpi light at the bottom of the mouse? ye that is very weak light for some reason, if an engineer can fix this or you guys have a fix for it that's guaranteed please don't hesitate to tell me, can u help me?

Answers

You should open it up from the back by removing the sticky grips at the bottom. Water is probably still stuck in between the clickers or scroll wheel.

PLEASE HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Read the list of courses from a technical school (w3schools).

Which courses would prepare for you for a career in web development?
(Choose more than one answer)

Designing for Usability
Introduction to Networks
Technical Writing
Cybersecurity

Answers

The answer was, a). Designing for Usability and c). Technical Writing

Bob The Penguin is a real you-tuber, and he plays Mine-craft. Who is his owner?

Answers

Is this even a real question-?

the retention of encoded information over time refers to

Answers

It refers to Storage

what is the deffinition of a bus network topology. along with a list of benifits and disadvantages of using a bus topology with many devices attatched. will give brainliest if answer is complete and good.

Answers

Answer:

all nodes in the network are connected directly to a central cable that runs up and down the network. When there is a tiny network, it works quite well. The needed wire length is smaller than in a star topology. It's simple to add or delete devices from this network without affecting others. When compared to other network topologies such as mesh and star, it is quite cost-effective.

Explanation:

which shortcuts can you use for undo and redo?

Answers

Answer:

Control + Z = undo

Control + Y = redo

"Control + Z" and "Control + Y" can be used for undoing and redoing in most programs, such as Microsoft Word, and virtually any text editor.

Which business function is most critical for maintain overall organization, including meeting established standards and deadlines?a)Management)Finance)Sales)Human resources

Answers

The business function that is most critical for maintaining overall organization, including meeting established standards and deadlines, is the "Management."

This is because the function of management in any firm involves crucial decision making such as establishing standards, creating project timelines and deadlines, and maintaining the whole organization to achieve desired results.

Management as a business function creates goals for the business. They also establish standards, policies, visions, and missions.

Management responsibilities also include creating short-term and long-term goals, including maintaining the business's key assets.

Hence, in this case, it is concluded that the correct answer is option A. "management."

Learn more here: https://brainly.com/question/12109980

Answer:

Management

Explanation:

HELP ME!! DUE SOOON AND I DONT UNDERSTAND PLSSSS

Answers

i think that it’s isss 4

What is the answer I will give brainliest

Answers

Answer:

It should display

1

2

1

or

2

1

2

Explanation:

not positive, correct me if im wrong

1
2
1
orr
1
2
3
brainliest?

What are the consequences of digital footprint ?

Answers

Answer:

The digital footprint that is left behind can have repercussions in all areas of your teen's life, potentially resulting in missed job opportunities, public sharing of personal information, ruined relationships — or, in what is likely more relevant to them right now: Their parents finding out what they've been up to

Explanation:

Other Questions
what drug has recently become the worlds top-selling medication? what is 2+2+2+2+2+7+7+8+8+9+9+0+0-0 Francine ran 3 laps around the track. If the track was 0.25 miles, how far did she run?What was her displacement at the end of her third lap? Explain the role of cytoskeleton Taxes are not necessary to the well being and operation of our nation.TrueFalse i havent made any plans for easter.Iam staying at home Need the answer for this please answer this!!! PLEASE HELPCompare -3 and 9. Which of the following is trueA. -3 < 9 and -3 < 9B. -3 = 9 and -3 < 9C. -3 > 9 and -3 < 9D. -3 > 9 and -3 > 9 PLEASE HELP WILL MARK BRAINLIEST TO BEST ANSWER If you are good with limits in calculus can you help me solve this problem please : Which term is -39 in the sequence 33,25,17,9,1,-7,... I need help on this asap please don't take the points if you do know the answer. Help pls its due tomorrow 50 points if you complete this reading the last thing then the second then the firstI'll give you a brainiest If you had excess chlorine, how many moles of aluminum chloride could be produced from 12.0g of aluminum what does this equal? show your work pls Directions: Read the short story below and answer the question."Eight Families From California Left Behind"In 2021 the U.S. decided to end its longest war and withdraw its soldiers from the country. Suddenly, however, the government fell and chaos gripped Kabul. In August, U.S. troops hurried to get Americans and allies out of the country, and the last U.S. soldier left on August 31. Yousef's wife and children were among eight families from El Cajon who were left behind. Yousef's family and several other families finally got out of Afghanistan. The Cajon Valley Union School District and their representative in Congress, Republican Darrell Issa, assisted them. Several of the families spoke to reporters last week. Yousef asked that only his first name be used in this story because he still has relatives in Afghanistan who could be at risk. The parents described running with their kids as gunfire whizzed overhead. One father said he was beaten by the Taliban. They said they were kept from getting to the airport by Taliban checkpoints.They said they are grateful to be back in the U.S., but that they worry about the family members unable to get out.Question: Why did Yousef only want to give his first name? pls help and I need more than one answer instead of one person pls A parallel plate air capacitor of value C, is charged to a potential V, betweenthe plates and +9, is charge on one plate. Separation between plates is d. Adielectric of dielectric constant K = 3 fills the space between the plates. Whichof these quantities will change and why. (i) capacitance (ii) charge (iii) po-tential difference and (iv) field density? pls help me with these questions