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