View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry B Smith Jerry B Smith is offline
external usenet poster
 
Posts: 2
Default Yes or No Value if Dollar amount between two numbers

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