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.

 

[shellwig]

Thank you very much for all your responses. I might not have explained it well enough but Asbsetos_Jen response seem to have satisfy all my conditions. Again Thank you!

 

[Scott Huish]

Something like this:
=IF(ABS(A4/A1)>2,"NM",A4/A1)

Sorry for the late response, I guess I didn't actually hit the Reply button. LOL

 

[Joe4]

Thank you very much for all your responses. I might not have explained it well enough but Asbsetos_Jen response seem to have satisfy all my conditions. Again Thank you!

My earlier post should do the exact same thing as that post.
Did you even try it?
I do not see any situation in which my formula would not return the same result as hers.
Perhaps you just don't understand what the ABS function does. It totally eliminates the need for an OR, so makes the formula a little shorter/simpler.
See: ABS Function