Not sure if need multiple IF statements or OR statement?

[shellwig]

Hello - I'm trying to build a formula where , IF result is >200%, return "NM", IF results is <200%, return "NM" but if result is between those parameters then calculate the result. Thank you in advance.

 

[dreid1011]

Maybe something like this:

=IF( OR( result > 200%, result < 200%),"NM", other calculation here)

this is just an idea of what your formula might look like.

 

[hagia_sofia]

Or

=LET(
a,(A2/A1>-200%)*(A2/A1<200%)*(A2/A1),
IF(a=0,"NM",a))

 

[shellwig]

Thank you for the responses but neither formula is providing a solution to all 3 results.

 

[Fluff]

In what way?

 

[dreid1011]

Thank you for the responses but neither formula is providing a solution to all 3 results.

Looking at the conditions you explained, it's impossible for it to perform the actual calculation unless it was exactly 200%.
Anything other than 200% will satisfy the OR conditions...

"NM" result > 200% < result "NM"

So only 200% would trigger your third result.

 

[dreid1011]

Maybe the OR should be like this:

OR(A2/A1>200%,A2/A1<-200%)

 

[Joe4]

Hello - I'm trying to build a formula where , IF result is >200%, return "NM", IF results is <200%, return "NM" but if result is between those parameters then calculate the result.

I am guessing that you misspoke, and for the part in red you meant to say "<-200%".

If so, try this formula (for your first calculation on cells A1 and A2):

=LET(p,A2/A1,IF(ABS(p)>200%,"NM",p))

and just change the "A2" to "A4" and "A6" for your other 2 calculations.

 

[Asbestos_Jen]

I made the same assumption as others; that you want NM if the result is >200% or <-200%.

=LET(r,A2/$A$1,IF(OR(r>2,r<-2),"NM",r))

 

[Joe4]

Note that the use of the ABS function allows you to bypass the need for an OR altogether.