1answer.
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]
3 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]3 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
​if a primary key combines two or more fields, then it is called a _____.
spin [16.1K]

Answer:

Composite primary key, or simply, composite key

Explanation:

When multiple fields (columns of a table) are combined to form a primary key, the resulting key is called a composite key.

Hope this helps!

3 0
4 years ago
The letters G, H, T, Y, B, and N are what type of keys?
andrey2020 [161]
Lower row keys. Your welcome
5 0
3 years ago
Read 2 more answers
What tool allows you to search external competitive intelligence research?
enot [183]

Answer:

SocialPeta

Explanation:

4 0
2 years ago
A window may be resized by dragging the___ or side of it
dangina [55]

top i believe is the answer


4 0
4 years ago
Read 2 more answers
A throw(...) statement is an alternative way to return from a function or method that indicates some kind of failure occurred.
WITCHER [35]

Answer:

a.True.

Explanation:

A throw statement is used to throw an exception from inside the method.Whenever the throw statement is encountered by the compiler and after that when it is executed the execution of the currently executing method is stopped and it returns back to caller.

There is also a keyword Throws which is used to tell the compiler that the method may throw one or more exceptions.

Hence we conclude that the answer is True.

6 0
4 years ago
Other questions:
  • Mary can view the thumbnails of her presentation slides when she is creating the slides. Which element of the program’s interfac
    5·2 answers
  • Write a function called matches that takes two int arrays and their respective sizes, and returns the number of consecutive valu
    6·1 answer
  • For which purpose is RAM used?
    7·2 answers
  • What are digital forensic techniques? A. Identifying, extracting, and evaluating evidence obtained from digital media such as co
    11·1 answer
  • Explain why interrupt times and dispatch delays must be limited to a hard real-time system?
    8·1 answer
  • How can a search be narrowed to only search a particular website????
    15·1 answer
  • The programming interface for a legacy motor controller accepts commands as binary strings of variable lengths.
    15·1 answer
  • Why media is far from government​
    6·2 answers
  • 3.<br>What is the meaning of *.VBP.<br>​
    6·2 answers
  • Decrypt this secret message if your able to a lot will come..
    14·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!