Rounding off "Quagmire"!

[panyagak]

Hi MrExcel

Am scratching my head on how to "further restrict for exactness" the numbers in my data analysis, for which have been using Joe4's formula as: =IF(ABS(ROUND(A1,0)-
A1)<=0.01,"KEEP","DUMP").

I need to go a step further as follows:
Lock out any number THAT IS NOT FOLLOWED BY 00 AFTER THE DECIMAL PLACE (.00.....) BEFORE ROUNDING. (All numbers are eventually rounded to 2 d.p. & filtered)

Example 1:
19.012432 = 19.01 DUMP
19.005433 = 19.01 KEEP

Example 2:
1.011234 = 1.01 DUMP
1.009343 = 1.01 KEEP.
Etc etc


The "Joe4's formula above" takes ALL as "KEEP".

Any tweak to it? OR a separate formula is needed?

Thank you.

Patrick.

 

[steve the fish]

Im not sure i follow. That formula applied to those examples will not produce 'KEEP' for them all.

 

[panyagak]

steve the fish

IT WILL KEEP ALL!!

Maybe you're misreading......

EXPOUNDED BELOW:

Example 1:
19.012432 rounded to 2 d.p. as 19.01= DUMP
19.005433 rounded to 2 d.p. as 19.01= KEEP

Example 2:
1.011234 rounded to 2 d.p. as 1.01= DUMP
1.009343 rounded to 2 d.p. as 1.01= KEEP.
Etc etc

 

[panyagak]

CLARIFICATION:

The examples at #3 is the output am looking for!

 

[steve the fish]

You dont need to use capital letters. I still dont follow.

 

[panyagak]

steve the fish

Why respond PAINSTAKINGLY to a SERIOUS ISSUE you dont "follow/understand "??!!!

A COMEDIAN!!

(Laughing..........!!)

 

[panyagak]

Extracting specific numbers

Hi Mrexcel experts.

Am in dire need.

I have large data sets, mostly doing analysis by columns.

To enhance more "exactness", I want to extract only those numbers that have a .00 (two zeroes) after the decimal place, as and when, they appear on column of interest:

Eg. as TRUE or FALSE: (These numbers are shortened)

2.00356565 TRUE
2.01356565 FALSE
15.0143245 FALSE
15.0043245 TRUE
7896.00767 TRUE
7896.01276 FALSE
934.013241 FALSE
934.003241 TRUE
Et cetera

Kindly help out.

Patrick

 

[Vbagreenhorn1]

Re: Extracting specific numbers

try this:

=MID(A1,SEARCH(".",A1)+1,2)="00"

 

[bosco_yip]

Re: Extracting specific numbers

Or,

=MOD(A1,1)<0.01

Regards

 

[steve the fish]

If I was a comedian I would tell a joke.