Yes or No Value if Dollar amount between two numbers

J

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?
 
J

John

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