View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sony Sony is offline
external usenet poster
 
Posts: 4
Default Finding number less than 1

I have a sorted column of prices. How can I program Excel to find the
location of the cell where the price starts to be less than one dollar, i.e.
1.00? As an example, I can't ask it to find say 0.99 as it may also find

12.99 for instance. This is part of a program. Thanks for any help.

Sony