Formula should be:

=IF(OR(B460,B4<21),"NOT","ELI")

greetz

"deen" schreef in bericht
...
Hi,

=IF(AND(B460<21),"NOT",IF(B421<60,"ELI"))

this formula not working,

i want result in A2 Not or ELI,

If thr is any possible do in macro pls let me abt the, bcoz new to the
macro.