Need help : what Loop i should use ?

[joh46k]

problem: I have two columns, One column in K and another one is in L column.

K column have percentages % and L column have Remarks . L column should automatically display "to be released" and "not to be released"

when certain condition are met , the condition is, when ( +/- 3% to be qualified to release)

[protonLeah]

Please Login or Register  to view this content.

[Max, Singapore]

One way

Try this in L5:
=IF(ISERROR(K5),"-",IF(K5="","",IF(AND(K5>=-3%,K5<=3%),"ok - to release","Not ok")))
Copy down. Modify to suit

This core part in the expression is the one that checks your tolerance limits of +/- 3%
... IF(AND(K5>=-3%,K5<=3%),....

As your data contain error values, these would need to be trapped right in front by:
=IF(ISERROR(K5),"-", ...

Lastly, this little bit below is needed ahead of the core tolerance checks as any blank cells are evaluated as zeros by Excel in formula calcs, hence blank cells would give you spurious returns
.. IF(K5="","", ....

--------------------------
Success and understanding? Wave it, Hit the little star at the bottom left of my responses