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

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

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of April 16, 2017.

For more resources for Microsoft Excel