Computers and Technology, 15.10.2019 00:20 smelcher3900

Insert an if function in cell f5 to calculate the total due. if the customer has chosen home delivery, there is an additional delivery charge located in cell b25. be sure to use appropriate relative and absolute cell references

Answers: 3

Show answers

Answers

The IF function receives a condition and gives a certain specified output if the condition is met and second output if the condition is false. The appropriate formular to perform the operation IS =IF((A5 = 'Yes'), $B$25+C5, C5)

Excel formulas start with an = signSyntax IF(Condition, True output, False output) A5 = 'Yes' : if the customer requested home delivery Additional charge for home delivery is kept in B25, here we need an absolute reference because we do not want the cell value to change as we move theorgh rows and columns, hence, the need for the $ signs for both row and column cell. Extra fee is added to total cost in cell C5 = $B$25 + C5If the condition is not met, that is, A5 = 'No' ; then return C5.

Therefore, the required formula in cell F5 should be

=IF((A5 = 'Yes'), $B$25+C5, C5)

Learn more : link

Answer from: byronanderson

=IF((D5="Yes"),(C4*1.05),C4)

Explanation:

If condition accepts 3 parameters, where the 1st parameter is the condition and second parameter is the one which needs to be executed “if the condition is true” and the third argument is executed when the “condition is false”.

Here the condition is if there is an delivery ie. D5 = yes, then we add some amount of additional charges through the formula (c4*1.05) and if not we retain the base price C4.

Here the additional delivery charges are considered as 5%. You can change the number according to your need.

Answer from: Quest

answer; i believe the correct answer is : communicate safe work practices;

Answer from: Quest

some have built technology like spoofed call blockers into their networks, so there's nothing you would even have to install.

this happens because the number is known for scamming, they don't want it to me known as "scam likely." perhaps it's just a telemarketer. maybe it's an identity thief. it might even be a scam artist.

either way, "scam likely" is probably not an old friend whose number you forgot that you saved. it's your wireless carrier's way of letting you know: answer at your own risk.

explanation:

to combat the seemingly rising epidemic of spam callers in the u.s., the nation's four major wireless carriers have been trying out new methods to reduce the number of unsolicited calls americans receive each day.

some have built technology like spoofed call blockers into their networks, so there's nothing you would even have to install.

hope this . mark me brainliest.

Another question on Computers and Technology

Computers and Technology, 22.06.2019 10:40

"it security policy enforcement and monitoring" respond to the following: describe how monitoring worker activities can increase the security within organizations. describe the rationale that managers should use to determine the degree of monitoring that the organization should conduct. explain the extent to which you believe an organization has the right to monitor user actions and traffic. determine the actions organizations can take to mitigate the potential issues associated with monitoring user actions and traffic.

Answers: 3

Answer

Computers and Technology, 22.06.2019 23:30

In my email i got a message it says a quick message and in message details on who its from its says nicole and under nicole is [email protected] -

Answers: 1

Answer

Computers and Technology, 23.06.2019 14:30

Select the correct answer. a company wants to use online methods to target more customers. it decides to conduct a market research by collecting the data of a few customers with their consent. they want to track data of the sites that their customers frequently visit. which software can the company? a. spyware b. bots c. adware d. trojan horse e. rootkits

Answers: 1

Answer

Computers and Technology, 24.06.2019 01:00

What shows the web address of the page that is currently displayed in the workspace? status window toolbar location bar internet box

Answers: 1

Answer

You know the right answer?

Insert an if function in cell f5 to calculate the total due. if the customer has chosen home deliver...

Questions