Yes or No Value if Dollar amount between two numbers

[Jerry B Smith]

I want a field to report a yes or no value if a dollar amount from another
field is between two numbers. For example, if the value is greater than 100
but less than 200, I want it to say "Yes". If outside these numbers, I want
it to say "No". Any suggestions?

 

[John]

Hi Jerry
Try this :
=IF(AND(J17>=100,J17<=200),"yes","NO") change range to your needs
HTH
John