I've a data(#of products sold in a day) in Column 'D' to 'L', I am trying to
find out the sales target achieved by each Employee. Targets are given in
column P. If none of the items are sold then i want it to display "none"

D E F G H I J K L

3 4 1 10 1 1 1 1

I tried get the result with this formula, but it goes wrong somewhere.
=IF(SUM(D7:L7)=0,"None",(IF(AND(D7=$P$4,E7=$P$5, F7=$P$6,G7=$P$7,H7=$P$8,I7=$P$9,J7=$P$10,K7= $P$11,),"Achieved",IF(OR((D7<$P$4)*(D70),(E7<$P$5 )*(E70),(F7<$P$6)*(F70),(G7<$P$7)*(G70),(H7<$P$ 8)*(H7=0),(I7<$P$9)*(I70),(J7<$P$10)*(J70),(K7<$ P$11)*(K70),),"NOT Achieved","Achieved"))))

I've more than 360 rows of data, could any please let me know where I've
gone wrong or if there's any other way to get the desired result

Thanks and regards
--
Karthi