Hi
=IF(AND(B5=1.5,B5<=1.99),10,"not defined")

--
Regards
Frank Kabel
Frankfurt, Germany
"govworker" schrieb im Newsbeitrag
...
How do I get excel to search through a range of numbers for example the
equation that I would like to complete is IF(B5=1.99 - 1.5,10) but excell
thinks that 1.99 - 1.5 is 1.99 minus 1.5. Please help.

Matthew