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.