OR and IF function for multiple values

Question

I'm attempting to check a condition across numerous cells using the "OR" function in the "IF" function. My formula reads as follows: =IF((OR(I5,N5,J5,O5)>7),"Greater than 7 MPa",IF((OR(I5,N5,J5,O5)4),"Less than 4 MPa","")) It always returns "Greater than 7" even when there are values in the cells that are less than 7. I've included a screenshot of the situation.

Answer 1

Your OR functions will always return TRUE if a non-zero value is entered in any of the cells being checked when used in their current format.

I propose the following modification:

=IF(OR(I5>7,N5>7,J5>7,O5>7),"Greater than 7 MPa",IF(OR(I5<4,N5<4,J5<4,O5<4),"Less than 4 MPa",""))