Spliting amount column between round dollar amounts and uneven amounts

Hello!

I have created a macro that splits my amount column between round dollar amounts (like $100,$500,$1000,$4300) and uneven amounts (something like $ 743/$881/$29,064,etc). This macro works perfectly on my current data set. Attaching both my dataset (named round dollar amounts) and the macro.

However, when I try to use this macro on a different excel file (attached as dataset 1) that contains various other columns (like date, description, name, address and amount), I do not get the desired output. The amounts in the other dataset are in decimals and I want to filter out the decimal values and the rounded values. Would be great if anyone can help me with this. Thanks!

Round Dollar Amounts macro.yxmc

Round dollar amounts.xlsx

Dataset 1.xlsx

Macros

Expression

Accepted answers

nagakavyasri

try this and use with your macro:

Macro with chart.yxzp

Macro and chart.yxmd

All comments

nagakavyasri

Check if changing the datatype to FixedDecimal with 0 decimal places meets your requirement:

Output:

Madhur12

Thanks! But this rounding off the decimals (like rounding off 10.81 to 11).

I simply want it to filter the round dollar amounts (amounts that are a multiple of 10). Any help with this ?

Thanks!

Madhur12

Awesome! This worked exactly as I wanted it to. I am now trying to add a pie chart to see how much of my data set is true and how much is false. But I am not able to make this work. Attaching my final macro. Can you please guide me for this as well?

Thanks!

Round Dollar Amounts macro.yxmc

nagakavyasri

try this and use with your macro:

Macro with chart.yxzp

Macro and chart.yxmd

Madhur12

This works, appreciate your response! Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703