Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started