Explain the difference between an IIf function and a nested IIf ...

[DyllonKazuo]

Explain the difference between an IIf function and a nested IIf function. Give two examples of when you would use each one.
 
  What will be an ideal response?

Question 2

Permissions denote the kind of changes a SharePoint user can make.
 
  Indicate whether the statement is true or false

[okolip]

Answer to Question 1

If functions can be used to determine if a specific condition is true or false. The IIf function introduces decision making into a database. Depending on whether or not specified criteria are met, the IIf function will return a different result depending on the outcome of the condition. Student examples will vary. Some ideas include searching for whether or not an employee is scheduled to work on a given day, whether or not a product is out of stock, or whether or not a customer has redeemed a specific coupon.
There are many occasions when you need to test for multiple conditions. A nested IIf function is when one IIf function is placed inside another. This allows a user to evaluate a series of dependent expressions. Student examples will vary. Some ideas include converting students' grades from a percent to a letter grade, determining how much inventory to order based on in-stock inventory counts, or how much of a salary increase an employee will receive based on a performance evaluation score.

Answer to Question 2

TRUE

[DyllonKazuo]

Wow, this really help

[shailee]

Excellent