Obviously you mean the value in B89 is a string containing two numbers
separated by a space-dash-space. Those two numbers really should be put into
two individual cells, but if this cannot be done then...(here goes)...try
this crazy formula:

=IF(AND(F90=VALUE(LEFT(B89,FIND(" -
",B89)-1)),F90<=VALUE(RIGHT(B89,LEN(B89)-FIND(" - ",B89)-2))),"YES","NO")

"Reggie" wrote:

I working on a form where there is a Value in cell B89 and there is a value
in cell F90. I need excel to determin if the value in F90 falls in the range
of the value for cell B89..

example:

cell B89 value = 3.5 - 5.0 (not minus sign) this values also changes...
Cell F90 value (user entered value) = 4.5

i need excel to see if 4.5 falls in the range of 3.5 - 5.0