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/7961-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

Frank Kabel

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

govworker

Thank you for your help. It worked great.

"Frank Kabel" wrote:

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

All times are GMT +1. The time now is 05:21 PM.