Which function calculates the Reduction in C2 to be filled through the rest of the reduction column if silver members have a 5% discount, gold 10% and Platinum have 20%?
A B C
| 1 | Level | Price | Reduction |
| 2 | Silver | 125 | ? |
| 3 | Gold | 125 | |
| 4 | Platinum | 125 |
=IF (A2="Silver”, B2*0.05, IF (A2="Gold”, B2*0.1, B2*0.2)
You might also like to view...
__________ key encryption schemes are secure if the public key is authenticated.
A. Message B. Management C. Public D. Private
When designing an expression for a calculated field, field names are surrounded by:
A) brackets. B) double-quotation marks. C) braces. D) parentheses.
A customer complains that data files cannot be opened on the primary system from Windows Explorer/File Explorer, but are opened normally on other systems. Which of the following is the most likely problem with the primary system?
a. Incorrect file attribute b. Drive errors c. Virus or malware d. Missing file association
Presentations can be organized inductively, deductively, sequentially (chronologically), _____, or as a problem/solution.
A. conclusively B. in a rotation C. spatially D. publicly