answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
marta [7]
2 years ago
8

Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1. The commission rate is 2% for al

l sales that total more than $10 and 1% for all sales that total more than $5. No commission is paid on sales that total $5 or less. Reference the threshold levels (cells F13 and F14) in your logical tests for your IF function and the commission rates (cells G13 and G14) as your "value_if_true" and "value_if_false" arguments. Use appropriate relative and absolute references.
Computers and Technology
1 answer:
katrin2010 [14]2 years ago
7 0

Answer:

IF Function!H18: =IF(G18>$F$14,$G$14,IF($F$14>G18>$F$13,$G$13))

You might be interested in
Hyper Text Transfer Protocol (HTTP) and Secure HTTP (HTTPS) are the same protocol from a standpoint of passing or blocking them
earnstyle [38]
Answer is false...,.....
5 0
2 years ago
What is a dashed line showing where a worksheet will be divided between pages when it prints?
barxatty [35]
The answer is A. A split box
7 0
2 years ago
Read 2 more answers
Edhesive: Assignment 4: Evens and Odds
solniwko [45]

Answer:

Written in Python

n = int(input("How many numbers do you need to check? "))

odd = 0

even = 0

for i in range(1,n+1):

     num = int(input("Enter Number: "))

     if num%2 == 0:

           print(str(num)+" is an even number")

           even = even + 1

     else:

           print(str(num)+" is an odd number")

           odd = odd + 1  

print("You entered "+str(even)+" even number(s).")

print("You entered "+str(odd)+" odd number(s).")

Explanation:

<em>I've added the full source code as an attachment where I use comments (#) as explanation</em>

Download txt
6 0
2 years ago
8. In time series, which of the following cannot be predicted? A) large increases in demand B) technological trends C) seasonal
Lesechka [4]

Answer: Random fluctuations.

Explanation: Time series is a series that has all the points of time in a equal time order.So, there is usually organised and having equal gaps sequence. It can be imposed on many data  like real value data, discrete data,continuous data . But there is no space for the space of randomness so, random fluctuations are not predictable in it.Therefore the option (D) is the correct option.

6 0
2 years ago
Harmful programs used to disrupt computer operation, gather sensitive information, or gain unauthorized access to computer syste
Wewaii [24]

Answer:

B. Malware

Explanation:

Malware is general to most harmful programs on a computer, as Adware is a potentially unwanted program that is designed to advertise other programs or services. And ransomware is a program that will encrypt important user files such as; documents, pictures, and videos. Spyware is a program that is designed to spy on users, examples are; using your camera without your consent, key-loggers, and taking screenshots of our desktop. Thus i believe it is malware because the question covers multiple categories.

6 0
2 years ago
Other questions:
  • What is a cursor?
    6·2 answers
  • Problem statement: Using loop, write a program that will ask the user to enter a character for left or right. Then, the user wil
    13·1 answer
  • I can't imagine any reason _______ he should have behaved in such an extraordinary way. for that why how
    8·1 answer
  • Desmond works in Power, Structural, and Technical Systems. He would most likely be employed by
    5·2 answers
  • The groups_per_user function receives a dictionary, which contains group names with the list of users. Users can belong to multi
    11·1 answer
  • reAay ouyay aay hizway ithway igPay atin?Lay? (Translated: "Are you a whiz with Pig Latin?") Write a program that converts an En
    6·1 answer
  • Describe a strategy for avoiding nested conditionals. Give your own example of a nested conditional that can be modified to beco
    15·1 answer
  • On the planet Sigma, robots excavate chunks of a very precious cristaline. These chunks can be divided into smaller part only on
    15·1 answer
  • Which of the following is not true of how computers represent complex information
    5·2 answers
  • Sea level is the average level of the sea between high and low tide. It is used as a reference point for measuring elevation, or
    11·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!