Yes or No Value if Dollar amount between two numbers
Hi Jerry
Try this :
=IF(AND(J17=100,J17<=200),"yes","NO") change range to your needs
HTH
John
"Jerry B Smith" wrote in message
...
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?
--
JerryS
|