In order to make sure the excel returns a clean format, the IF equation will be commonly used, and the IF equation will have the following format
= IF (1st Statement, 2nd Statement, 3rd Statement)
Where
- 1st Statement = Tested Condition to match desired requirement such as greater or less than a certain value.
- 2nd Statement = Return Value or expression if the tested condition in the 1st statement passed.
- 3rd Statement = Return Value or expression if the tested condition in 1st statement failed.
The following table will explain what type of expression was required for USL & LSL. (where “” = blank value)