Multiple Logical Test in IF formula

[nickbert_81]

Hi All,

I am trying to return a status in the following table

[TABLE="width: 367"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Flange Rating
[/TD]
[TD]Lowest Value
[/TD]
[TD]Status
[/TD]
[/TR]
[TR]
[TD]Example1
[/TD]
[TD]150
[/TD]
[TD]1.0
[/TD]
[TD] X
[/TD]
[/TR]
[TR]
[TD]Example2
[/TD]
[TD]150
[/TD]
[TD]1.5
[/TD]
[TD] X
[/TD]
[/TR]
[TR]
[TD]Example3
[/TD]
[TD]450
[/TD]
[TD]6.0
[/TD]
[TD] X
[/TD]
[/TR]
[TR]
[TD]Example4
[/TD]
[TD]450
[/TD]
[TD]6.3
[/TD]
[TD] X
[/TD]
[/TR]
</tbody>[/TABLE]

Based on the following conditions

[TABLE="width: 316"]
<tbody>[TR]
[TD="colspan: 2"]Flange Rating
[/TD]
[TD="colspan: 2"]Lowest Value
[/TD]
[TD] Status
[/TD]
[/TR]
[TR]
[TD]<
[/TD]
[TD]400
[/TD]
[TD]<
[/TD]
[TD]1.3
[/TD]
[TD]Fail
[/TD]
[/TR]
[TR]
[TD]<
[/TD]
[TD]400
[/TD]
[TD]>
[/TD]
[TD]1.3
[/TD]
[TD]Pass
[/TD]
[/TR]
[TR]
[TD]>
[/TD]
[TD]400
[/TD]
[TD]<
[/TD]
[TD]6.2
[/TD]
[TD]Fail
[/TD]
[/TR]
[TR]
[TD]>
[/TD]
[TD]400
[/TD]
[TD]>
[/TD]
[TD]6.2
[/TD]
[TD]Pass
[/TD]
[/TR]
</tbody>[/TABLE]

Please help with the correct formula to use?

Thankyou

 

[Aladin Akyurek]

Try...

=IF(B2 < 400, IF(C2 < 1.3, "fail", "pass"), IF(C2 < 6.2, "fail", "pass"))