OR and IF function for multiple values

0 votes

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.

Screenshot

Feb 13, 2023 in Others by Kithuzzz
• 38,010 points
309 views

1 answer to this question.

0 votes

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",""))
answered Feb 13, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

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

answered Feb 11, 2023 in Others by Kithuzzz
• 38,010 points
253 views
0 votes
0 answers

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

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

May 23, 2022 in Others by Kichu
• 19,050 points
2,050 views
0 votes
1 answer
0 votes
1 answer
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17, 2022 in Others by Edureka
• 13,670 points
660 views
0 votes
1 answer

Remove formulas from all worksheets in Excel using VBA

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

answered Oct 3, 2022 in Others by narikkadan
• 63,420 points
1,336 views
0 votes
1 answer

Calculate monthly average from daily data without PivotTable

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

answered Oct 3, 2022 in Others by narikkadan
• 63,420 points
1,190 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

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

answered Oct 7, 2022 in Others by narikkadan
• 63,420 points
934 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,420 points
920 views
0 votes
1 answer

Excel function for divide or split number to maximum possible equal parts

The underlying math for this is as ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 63,420 points
1,798 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP