How do I put logical operators in an Excel =IF Formula?
Fresh3 days ago
Mar 15, 2026124249 viewsConfidence Score0%
0%
Problem
I'm trying to enter a formula to display text according to an IF condition. The best I can manage is something like... But this appears to work exactly wrongly, displaying OK when myval is out of range and Not OK when it is in range. How do I specify the logical AND correctly? I have tried && as I …
Error Output
=IF(myval>=minval & myval <= maxval, "OK", "Not OK")
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do I put logical operators in an Excel =IF Formula?
Low Risk
The logical operations are represented by formulae: Each condition can be pretty much anything with a logical evaluation, meaning you can nest logical operations by nesting the formulae as required. So in your case you need:
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix