Excel: 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


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

This thread is current as of April 16, 2017.


For more resources for Microsoft Excel