Microsoft Excel - IF Formula - Pass or Fail a Quality Test
In our vlog this week we take a deep dive into how to write an IF formula, to determine whether an item passes or fails a certain value.
We used a manufacturing example of creating products - are they good enough to pass the quality test?
But this Formula can be used on a solution where there are logical comparisons between values.
We have also shown how Conditional Formatting can enhance this worksheet, immediately making it clear if it's a Pass or Fail by using colour.