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
1	0.01	DUMP
2	0.02	DUMP
3	6.25	KEEP
4	34.5	KEEP
5	8.75	KEEP
6	9	KEEP
7	1.98	KEEP
8	5.99	KEEP
9	9.26	DUMP

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B1 =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"))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

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!!