Extracting whole numbers (+ - 0.02 or 0.01) & ending in .25, .50, .75

[panyagak]

Dear ALL MrExcel

Formula for 1st problem is this:

=IF(ABS(ROUND(A1,0)-A1)<=0.02,"KEEP","DUMP").
(a) (The formula above also KEEPS 0.01s & 0.02s which I dont need). I need to incorporate an extra formula in it.

(b) I also need to extract all numbers ending in .25, .50 and .75 & need to incorporate it in the above formula:

ANY SINGLE EXTENDED FORMULA TO INCORPORATE THE 2 EXTRA CONDITIONS FOR SIMPLICITY?

Thanks.

Regards Patrick

 

[panyagak]

AliGW

Hope it has worked on rows 7 & 8. Thanks for your efforts. Will try it out

Have a Super Easter Monday (Muslims or Indians celebrate it!!!??).

All in all thanks

Regards
Patrick in rural Kenya

 

[AliGW]

Yes, it worked:

Excel 2016 (Windows) 32 bit

	A	B
DUMP
DUMP
KEEP
KEEP
KEEP
KEEP
KEEP
KEEP
DUMP

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]0.01[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]0.02[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]6.25[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]34.5[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]8.75[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]9[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]1.98[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]5.99[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]9.26[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B1[/TH]
[TD="align: left"]=IF(MROUND(ABS(A1),0.25)=ABS(A1),"KEEP",IF(ABS(A1)<=0.02,"DUMP",IF(ABS(ROUND(A1,0)-A1)<=0.02,"KEEP","DUMP")))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Happy Easter to you, too.

 

[panyagak]

Thanks AliGW & co.

Refer to:
=IF(MROUND(ABS(A1),0.25)=ABS(A1),"KEEP",IF
(ABS(A1)<=0.02,"DUMP",IF(ABS(ROUND(A1,0)-
A1)<=0.02,"KEEP","DUMP")))

However, the formula returns "KEEP" for 0.00. Try on 0.00 on your PCs.

Please any modification?

Thanks.

 

[panyagak]

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

Hope this helps!!