Comparing Values from 2 cells
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
|