ExcelBanter - How do I get excel search through a range of numbers e.g. 1.99

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I get excel search through a range of numbers e.g. 1.99 - . (https://www.excelbanter.com/excel-worksheet-functions/7962-how-do-i-get-excel-search-through-range-numbers-e-g-1-99-a.html)

govworker

How do I get excel search through a range of numbers e.g. 1.99 - .

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

All times are GMT +1. The time now is 10:36 PM.