Excel IF Statement with a logical test that asks \"is this value between N2 and

Question

Excel IF Statement with a logical test that asks "is this value between N2 and N2

Hi all

I'm trying to write an EXCEL IF statement where the logical part involves testing whether the result of a formula's calculation is between, for example, -25 and 25.

I have tried various versions of =IF (A1 + A2/100 >-25 AND <25, "OK", "Not OK).

After several hrs on w.w.w. I have the impression that, shockingly, either this can't be done or the syntax and logic are way over my head.<br /><br />Thanks for any help.

Explanation / Answer

(*It's the syntax. There is no boolean AND operator in Excel. You need to use the AND() function, which requires complete statements. ><

=if(and(conditionOne,conditionTwo,....),trueStatement,falseStatement)

=IF (and(A1 + A2/100 >-25, A1 + A2/100 <25), "OK", "Not OK")

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.