Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filter for round numbers
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
filter for round numbers
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
round numbers in the millions to numbers in the thousands | Excel Worksheet Functions | |||
Round numbers up or down and always end in an 8 | Excel Worksheet Functions | |||
Round down numbers | Excel Worksheet Functions | |||
Round numbers THEN add them | Excel Worksheet Functions | |||
Can you round numbers to display a specific set of numbers, for e. | Excel Discussion (Misc queries) |