nickbert_81
New Member
- Joined
- Sep 24, 2017
- Messages
- 1
Hi All,
I am trying to return a status in the following table
<tbody>
</tbody>
Based on the following conditions
<tbody>
</tbody>
Please help with the correct formula to use?
Thankyou
I am trying to return a status in the following table
Name | Flange Rating | Lowest Value | Status |
Example1 | 150 | 1.0 | X |
Example2 | 150 | 1.5 | X |
Example3 | 450 | 6.0 | X |
Example4 | 450 | 6.3 | X |
<tbody>
</tbody>
Based on the following conditions
Flange Rating | Lowest Value | Status | ||
< | 400 | < | 1.3 | Fail |
< | 400 | > | 1.3 | Pass |
> | 400 | < | 6.2 | Fail |
> | 400 | > | 6.2 | Pass |
<tbody>
</tbody>
Please help with the correct formula to use?
Thankyou