Question

Given the following column values, what will the value of the column containing this function be?

[LoanBal] = 21000
[YearlyInc] = 35000
[Exc] = 3
IIF([LoanBal] > 21500, IIF([YearlyInc] > 34000, [Exc] * 500, [Exc] * 1000), 5000)

Answer 1

The column value containing the function is 5000, as determined by evaluating the given nested conditional statement using the provided column values.

Step-by-step explanation:

The value of the column containing the function you've provided will be determined through a nested conditional statement based on the given column values. Since [LoanBal] is less than 21500, the outer IIF condition is not satisfied, so we ignore the inner IIF and use the else part of the outer IIF, which is 5000. Therefore, the value of the column containing this function will be 5000.