Most valuable professional
  • Hot Topics

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

This article includes the following tags:

  • Excel
  • Microsoft Excel