Skip to main content
Participant
March 19, 2024
Question

Pass Fail based on a formula of a value in a different cell and multiple arguments

  • March 19, 2024
  • 0 replies
  • 277 views

In the attached document I am trying to have the PASS/FAIL cell automatically say Pass/Fail based on the value in the calculated error cells.  But the value is based on the values of the following statement.  +/- 5 deg. F or 0.5% of SAT System Reading (E) whichever is greater.  So basically I need it to look at the SAT System Reading and apply the Calculation of 0.5% to determine the min and max value.  If these values are greater thatn +/- 5 then apply the PASS FAIL based on that.  Otherwise use the +/- 5 to determine Pass Fail.

This topic has been closed for replies.