Re: Filter whole numbers with + - 0.02 or 0.01

[panyagak]

Re: Filter whole numbers with + - 0.02 or 0.01

Hi Joe4 & Happy Easter

Refer to the above title and below is your answer:
It works perfectly though 0.01s & 0.02s are also
"TRUE"- I dont need them.

Any way to lock them out by adjusting the code.

This formula will tell you which ones to Keep/
Dump (for an entry in cell A1):

Code:

=IF(ABS(ROUND(A1,0)-A1)<=0.02,"KEEP","DUMP")

Regards
Patrick

 

[AliGW]

Re: Filter whole numbers with + - 0.02 or 0.01

Where is the original formula that Joe4 gave you?

 

[Aladin Akyurek]

Re: Filter whole numbers with + - 0.02 or 0.01

@panyagak

1.05

0.8

2.01

3

How do you want to evaluate these?

 

[panyagak]

Re: Filter whole numbers with + - 0.02 or 0.01

=if(abs(round(a1,0)-a1)<=0.02,"keep","dump")

 

[panyagak]

Re: Filter whole numbers with + - 0.02 or 0.01

Dump
dump
keep
keep

 

[Aladin Akyurek]

Re: Filter whole numbers with + - 0.02 or 0.01

Dump
dump
keep
keep

The formula you have does exactly that. What is the problem?

 

[AliGW]

Re: Filter whole numbers with + - 0.02 or 0.01

This maybe?

=IF(ABS(A1)<=0.02,"DUMP",IF(ABS(ROUND(A1,0)-A1)<=0.02,"KEEP","DUMP"))

 

[panyagak]

Re: Filter whole numbers with + - 0.02 or 0.01

Aladin Akyurek

Please type in Excel
0.01
0.02
0.01
0.02
apply Joe4's formula, then refer to my problem!!

thanks

 

[AliGW]

Re: Filter whole numbers with + - 0.02 or 0.01

See my solution in post #7.

 

[panyagak]

Re: Filter whole numbers with + - 0.02 or 0.01

AliGW

I saw your post & formula: havent tested it yet BUT if it returns DUMP for;
0.01
0.02
0.01
0.02 in Excel, GREAT!!

Regards
Patrick