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. Feb 13 in Others 51 views

## 1 answer to this question.

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",""))`
• 59,740 points

## How to query a matrix for multiple values and receive value

Try: =IFERROR(INDEX(SORT(SORT(FILTER(MATRIX, (LENGTHS>length)*(WEIGHTS>weight)),1,1),2,1),1,3),1) , where MATRIX, LENGTHS, and WEIGHTS ...READ MORE

## React: Expected an assignment or function call and instead saw an expression

I want to fix lint error at ...READ MORE

## Excel 365 Formulas - How to save LAMBDA function permanently (for all existing and new files)?

Try creating a template for excel to ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## Remove formulas from all worksheets in Excel using VBA

Try this : Option Explicit Sub test1() ...READ MORE

## Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE

## Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE