View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Julieeeee Julieeeee is offline
external usenet poster
 
Posts: 10
Default filter for round numbers

Is there a way to filter or sort for only those values that have no cents? I
have a column of discount amounts, and I want to see only the flat rate
discounts and not the percentage discounts. The flat rate discounts would be
like 25.00 <-- always without any cents. Percentage discounts would
virtually always be like 25.34 or something like that.
Thanks!
Julie