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

You can use a helper column with a formula like this:

=IF(INT(D2)=D2,"Flat-rate","%age")

and copy this down. Then you can apply autofilter to this column,
selecting "Flat-rate" from the filter pull-down.

Hope this helps.

Pete

On Sep 23, 2:38*pm, Julieeeee
wrote:
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

Assuming that the 25 is 25 and not soemthing like 24.999999999994 as the
result of a calculation the use a helper column with the formula:

=E4=INT(E4)

or whatever the column/row is and copy down then filter of TRUE.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Julieeeee" wrote in message
...
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