←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

IF/OR Formula with multiple criteria not working as desired (365 for enterprise - beginner)

Our take

In your quest to create an effective IF/OR formula, it's essential to ensure that each condition is evaluated correctly. Your initial formula attempts to output "YES" for eligibility, but it only returns "NO" if any of the criteria are met. This behavior suggests that the formula might not be triggering as expected due to the interaction with the conditional formatting or data entry practices. To resolve this, review the conditions carefully and test with varying data inputs.

Hey all,

I'm trying to make an IF/OR that will generate a "YES" even if only one of the listed criteria is met.

Originally I was trying:

=IF(OR($B2>6,$C2<80,$D2<3775, $E2="Y"),"NO","YES")

Basically, if absences are greater than 6, Grade is lower than 80, STAAR score is less than 3775, OR Discipline = Y, then the output should be NO, the student is not eligible to exempt.

However what I'm seeing is that nothing is happening unless I enter the STAAR score. Even at zero absences, the data does not change to YES.

SO, I attempted a modified, more specific formula:

=IF(OR($B2>6,$C2<80, $C2>0,$D2<3775, $D2>1649, $E2="Y"),"NO","YES")

Even if I enter data that should result in a YES in the "Eligible?" column, it remains unchanged until I enter the STAAR score.

Other note, I do have conditional formatting on columns B, C, D, and E, but only to change the cell color if certain data are present. For example C2>6 will turn red, C<6, C>2 will turn yellow, and C<3 will turn green.

Please advise! Any help is appreciated.

submitted by /u/The-Sweetest-Pea
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#enterprise data management#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#big data performance#data analysis tools#data cleaning solutions#natural language processing for spreadsheets#AI formula generation techniques#rows.com#formula generator#Excel compatibility#row zero#Excel alternatives#enterprise-level spreadsheet solutions#financial modeling with spreadsheets
IF/OR Formula with multiple criteria not working as desired (365 for enterprise - beginner) | Beyond Market Intelligence