hi Mrexcel experts
Am trying to highlight cells meeting this formula criteria BUT am unable to do so - whether to exclude/include "KEEP" "DUMP" )));
=IF(MROUND(ABS(A1),0.25)=ABS(A1),"KEEP",IF(ABS(A1)<=0.02,"DUMP",IF(ABS(ROUND(A1,0)-A1)<=0.02,"KEEP","DUMP")))
Am trying to highlight cells meeting this formula criteria BUT am unable to do so - whether to exclude/include "KEEP" "DUMP" )));
=IF(MROUND(ABS(A1),0.25)=ABS(A1),"KEEP",IF(ABS(A1)<=0.02,"DUMP",IF(ABS(ROUND(A1,0)-A1)<=0.02,"KEEP","DUMP")))