View Single Post
  #1   Report Post  
govworker
 
Posts: n/a
Default 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