Question: This row ( 1 0 5 ) is used to calculate a decision rule for determining underutilization for the 8 0 % rule. If any
This row is used to calculate a decision rule for determining underutilization for the rule. If any ratio in Row is less than there may be a problem with discrimination. To calculate this value, you must use the IF function in Excel. The IF function is used because it will help to retrieve one value for a TRUE result, and one for a FALSE result.
The IF function is input as follows:
Where: logical test the value or expression that is to evaluated as TRUE or FALSE eg that the th rule is met;
valueiftrue the value that returns when the logicaltest evaluates as TRUE; and
valueiffalse the value that returns when the logicaltest evaluates as FALSE.
For the purpose of this assignment, you will refer to the values derived in row and assess whether they yield a TRUE or FALSE result will appear as or respectively Perform the function to find the rest of the values in the row.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
