A spreadsheet has multiple cells filled with the ranges like "$0 -
$500" or "$501 - $1000" or "Jan 2006 - March 2006".

Is there a way to make judgement programmatically (either using
function or procedure) to determine if a value falls in the range?

Thanks in advance.