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

G

govworker

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
How can I vary graph color by range value 3
Excel does not accept text format! 0
How do I install Microsoft Equation 3.0 back to Office 365? 0
Finding the right style field in VBA 0
Word: select text, search, delete, in a macro, how? 8
Get "Large" from List 1
Sumif apllying to all sheets in workbook 2

Top